BigQuery Materialized view: Query Limitations vs Creation Query Limitations

Question

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! JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

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