[ADAP-848] [Bug] BQ incremental materialization with _dbt_max_partition doesn't work for Preview in dbt Cloud with dbt show --inline

[dbeatty10]

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

See this internal Slack thread for details:
https://dbt-labs.slack.com/archives/C05FWBP9X1U/p1692582407653009

Expected Behavior

See internal Slack thread for details.

Steps To Reproduce

See above (and below).

{{
    config(
        materialized="incremental",
        incremental_strategy="insert_overwrite",
        partition_by={
            "field": "created_at_date",
            "data type: "DATE",
            "granularity": "day",
        })
}}

select * from {{ ref("incremental source date") }}
where created_at_date >= _dbt_max_partition

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-bigquery:

Additional Context

No response

[github-actions]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

[stelios-c]

Hi, I keep coming across this, please keep it open, and if possible, fix!

[colin-rogers-dbt]

Likely related to #583

[carolinabtt]

I created a PR that could also solve this issue by updating the bigquery__get_empty_subquery_sql macro. dbt-labs/dbt-bigquery#1369