CODEWITHSUNDEEP
google-bigquerymaterialized-views
Thirumalai Muthu Palani
Thirumalai Muthu Palani

Reputation: 123

Materialized view in Bigquery

I came across the following command in a documentation : bq mk --materialized_view

I would like to know whether the bq mk --materialized_view command in Bigquery creates a materialized view ?

Thanks Thirumalai

Upvotes: 0

Views: 3241

Answers (3)

ProGirlXOXO
ProGirlXOXO

Reputation: 2300

Materialized views is now GA.

Basic docs: https://cloud.google.com/bigquery/docs/materialized-views-intro

BQ CLI reference: https://cloud.google.com/bigquery/docs/reference/bq-cli-reference#mk-materializedview

Upvotes: 1

ktopcuoglu
ktopcuoglu

Reputation: 146

It is beta now:

BigQuery Materialized View are precomputed views that periodically cache results of a query for increased performance and efficiency. BigQuery leverages precomputed results from materialized views and whenever possible reads only delta changes from the base table to compute up-to-date results. Materialized views can be queried directly or can be used by the BigQuery optimizer to process queries to the base tables.

Queries that use materialized views are generally faster and consume less resources than queries that retrieve the same data only from the base table. Materialized views are helpful to significantly boost performance of workloads that have the characteristic of common and repeated queries.

https://cloud.google.com/bigquery/docs/materialized-views-intro

Upvotes: 1

Felipe Hoffa
Felipe Hoffa

Reputation: 59165

Materialized views are an alpha project - access is limited to a few accounts while the feature continues its development.

Please follow this issue for updates:

Upvotes: 1

Related Questions