Open Fleid opened 1 year ago
@mikealfare FYI
@Fleid @mikealfare this has been out there for a while now, I think it's basically impossible at this point that they would drastically change the functionality, as they have written it up and pulled it into official client libraries. ~Happy to try my hand at a PR for adding this if it would be welcome!~ Changing to an "ask for forgiveness instead of permission" approach https://github.com/dbt-labs/dbt-bigquery/pull/1011
Hello, any update on this? :)
As commented in the core MV thread, BigQuery is adding support for non-incremental MVs.
From our side, it means that we have an additional setting to support for MVs in BQ:
allow_non_incremental_definition
:true
/false
. This setting is covered byon_configuration_change
via DROP/CREATE since it can't be changed via ALTER.When set, it requires
max_staleness
to be set. I'd rather leave BQ errors out here for now - this is a preview feature and I'm not sure this won't change before GA. We should not check this.BigQuery
BigQuery Materialized Views
false
)on_configuration_change
.apply
: enable_refresh/refresh_interval_minutes/max_staleness via ALTER, rest via DROP/CREATE