Hi, does BigQuery support materialized views?

Question

Does BigQuery support materialized views? The documentation suggests to materialize the query output. does this mean materialized views are supported or is this as good as creating a new table with the query output?

Answer 1

Materialized views are not (yet) supported in BigQuery at the time of this writing. You can follow along with the relevant feature request, however. In the meantime, you need to create a table explicitly from a view, e.g.:

CREATE TABLE dataset.materialized_view AS
SELECT *
FROM dataset.view;