[Bug] hours to expiration timeformat is incorrect for materialized view

[karlohrn]

Is this a new bug in dbt-bigquery?

• I believe this is a new bug in dbt-bigquery
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

when setting the hours_to_expiration on a materialized view it fail to create the view due to incorrect format of option.

OPTIONS(
enable_refresh=True,

  refresh_interval_minutes=30,

  expiration_timestamp=2024-04-10 10:27:29.596776
)

Options for expiration_timestamp is not in the correct format

Expected Behavior

I expect the materialized view to be created and and have a expiration time set on the dataset.

Steps To Reproduce

create a dbt materialized view with a expiration time on the view.

Relevant log output

Syntax error: Expected ")" or "," but got integer literal "11" at [11:39]

Environment

- OS: mac
- Python 3.11.7
- dbt-core: 1.7.1
- dbt-bigquery: 1.7.2

Additional Context

No response