Describe the bug

I want to be able to use dbt "hours_to_expiration" to define BigQuery "Table expiration", but the configuration isn't being received.

Steps to reproduce

Just use a simple configuration for the Google Sheets and try to add the "hours_to_expiration" and validate that the option isn't added to BigQuery

version: 2

sources:
  - name: test
    loader: gcloud storage
    dataset: "{{ target.dataset }}"
    tables:
      - name: test
        description: Sheet
        hours_to_expiration: 24
        external:
          location: 'https://docs.google.com/spreadsheets/d/id'
          options:
            format: google_sheets
            skip_leading_rows: 1
            sheet_range: 'sheetrange'
        columns:
          - name: column_name
            data_type: STRING
            description: "Column Name"

Expected results

The table should be created with the Table expiration configured.

Actual results

Table expiration doesn't change from NEVER

System information

• BigQuery

The output of dbt --version:

Core:
  - installed: 1.5.2
Plugins:
  - bigquery: 1.5.3 - Up to date!

The operating system you're using:
Windows
The output of python --version:
Python 3.11.2