[bug] Fix ExecutionMode.AIRFLOW_ASYNC query

[tatiana]

Context

In Cosmos 1.7, we introduced experimental BQ support to run dbt models with ExecutionMode.AIRFLOW_ASYNC in #1224 and #1230.

While chatting with @joppevos , he identified that the dbt run command:

dbt run --full-refresh

the BQ adaptor seems to create or replace on top of the table, not a drop/create:
https://github.com/dbt-labs/dbt-bigquery/blob/455c76887c9886c517df9619335066bedb1e1a43/dbt/include/bigquery/macros/adapters.sql#L16

Only if the partitions or clusters have changed then it drops
https://github.com/dbt-labs/dbt-bigquery/blob/455c76887c9886c517df9619335066bedb1e1a43/dbt/include/bigquery/macros/materializations/table.sql#L27

Action

• Confirm this behaviour, by adding a breakpoint in the dbt run command
• Fix the query behaviour in Cosmos

[joppevos]

Thanks for creating the issue @tatiana! I see it's assigned, but I'd love to give it a shot or collaborate.