### Apache Airflow Provider(s)

google

### Versions of Apache Airflow Providers

google=8.5.0

### Apache Airflow version

2.4.3

### Operating System

Debian GNU/Linux 11 (bullseye)

### Deployment

Other Docker-based deployment

### Deployment details

_No response_

### What happened

The newest version of the google providers no longer provides the `field_delimiter` or `time_partitioning` fields to the bq job configuration for the GCStoBQ transfers. Looking at the code it seems like this behavior was removed during the change to use deferrable operations

### What you think should happen instead

These fields should continue to be provided

### How to reproduce

_No response_

### Anything else

_No response_

### Are you willing to submit PR?

- [x] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"Loaded BQ data with MAX value of column %s.%s: %s",
                        self.destination_project_dataset_table,
                        self.max_id_key,
                        max_id,
                    )
                    return str(max_id)
            else:
                raise RuntimeError(f"The {select_command} returned no rows!")
    def _check_schema_fields(self, table_resource):
        """
        Helper method to detect schema fields if they were not specified by user and autodetect=True.
        If source_objects were passed, method reads the second row in CSV file. If there is at least one digit
        table_resurce is returned without changes so that BigQuery can determine schema_fields in the
        next step.
        If there are only characters, the first row with fields is used to construct schema_fields argument
        with type 'STRING'. Table_resource is updated with new schema_fileds key and returned back to operator
        :param table_resource: Configuration or table_resource dictionary
        :return: table_resource: Updated table_resource dict with schema_fields
        """
        if not self.autodetect and not self.schema_fields:
            raise RuntimeError(
                "Table schema was not found. Set autodetect=True to "
                "automatically set schema fields from source objects or pass "
                "schema_fields explicitly"
            )
        elif not self.schema_fields:
            for source_object in self.source_objects:
                gcs_hook = GCSHook(
                    gcp_conn_id=self.gcp_conn_id,
                    delegate_to=self.delegate_to,