CODEWITHSUNDEEP
google-bigquerymaterialized-views
M4rk
M4rk

Reputation: 2272

BigQuery Materialized view: Query Limitations vs Creation Query Limitations

In the official guide, it names several limitations of BigQuery Materialized Views: https://cloud.google.com/bigquery/docs/materialized-views-intro#:~:text=Each%20base%20table%20can%20be,rewrite%20(or%20smart%20tuning).

However I don't fully understand if these limitations apply to the creation of a view: e.g.

CREATE MATERIALIZED VIEW project-id.my_dataset.my_mv_table AS
SELECT #### THIS QUERY HAS LIMITATIONS ######
GROUP BY date

OR if there are limitations in querying the materialized view. e.g.

SELECT * FROM project-id.my_dataset.my_mv_table LEFT JOIN #### and some other complex query pattern ####

Does querying the materialized view itself (once created) has limitations at all that I should be aware of (or documented anywhere?). I couldn't find any specific documentation to it

Thank you all!

Upvotes: 1

Views: 2763

Answers (1)

Tom E
Tom E

Reputation: 421

Here's a bit more info around what limitations there are for materialised views in bigquery link.

In answer to your question, the limitations are for the query used in the creation of the materialised view and not when you're querying the materialised view.

Hope this helps! Tom

Upvotes: 4

Related Questions