当BigQuery非增量材料化视图未按预期刷新时,可以考虑以下解决方法:
REFRESH MATERIALIZED VIEW mydataset.mytable;
SELECT * FROM INFORMATION_SCHEMA.MATERIALIZED_VIEWS WHERE TABLE_NAME = 'myview';
ALTER MATERIALIZED VIEW mydataset.myview ENABLE AUTO_REFRESH;
REFRESH MATERIALIZED VIEW mydataset.myview;
SELECT * FROM INFORMATION_SCHEMA.MATERIALIZED_VIEW_REFRESH_SCHEDULES WHERE TABLE_NAME = 'myview';
确保刷新计划的设置与预期一致。
通过采取以上步骤,你应该能够解决BigQuery非增量材料化视图未按预期刷新的问题,并确保其正确引用基表。