You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Conflicting generated query names in BQ merge statements
Issue description
BigQuery merge statements that are generated for incremental tables use SOURCE and DEST as the names of the internal select queries. These are fairly generic, and if a user provide model select statement references a field with a name of "source" or "dest", the users query will not behave as expected.
I propose changing these references to something far more unique and unlikely to conflict with users queries, such as DBT_INTERNAL_DEST and DBT_INTERNAL_SOURCE.
The text was updated successfully, but these errors were encountered:
Issue
Conflicting generated query names in BQ merge statements
Issue description
BigQuery merge statements that are generated for incremental tables use SOURCE and DEST as the names of the internal select queries. These are fairly generic, and if a user provide model select statement references a field with a name of "source" or "dest", the users query will not behave as expected.
I propose changing these references to something far more unique and unlikely to conflict with users queries, such as DBT_INTERNAL_DEST and DBT_INTERNAL_SOURCE.
The text was updated successfully, but these errors were encountered: