### 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)

"""
    Asserts that a task is deferred and a BigQueryInsertJobTrigger will be fired
    when Operator is executed in deferrable.
    """
    hook.return_value.insert_job.return_value = MagicMock(job_id=pytest.real_job_id, error_result=False)
    hook.return_value.generate_job_id.return_value = pytest.real_job_id
    hook.return_value.split_tablename.return_value = (PROJECT_ID, DATASET, TABLE)
    hook.return_value.get_job.return_value.result.return_value = ("1",)
    operator = GCSToBigQueryOperator(
        task_id=TASK_ID,
        bucket=TEST_BUCKET,
        source_objects=TEST_SOURCE_OBJECTS,
        destination_project_dataset_table=TEST_EXPLICIT_DEST,
        write_disposition=WRITE_DISPOSITION,
        schema_fields=SCHEMA_FIELDS,
        external_table=False,
        autodetect=True,
        deferrable=True,
    )
    with pytest.raises(TaskDeferred) as exc:
        operator.execute(create_context(operator))
    assert isinstance(
        exc.value.trigger, BigQueryInsertJobTrigger
    ), "Trigger is not a BigQueryInsertJobTrigger"
def test_execute_without_external_table_async_should_throw_ex_when_event_status_error():