Learning Google BigQuery

Views

BigQuery supports creating views, but they are not materialized views and the underlying query for a view is executed each time someone runs a query on the view. A view can be defined using legacy SQL or standard SQL, but the limitation is that if a view is defined in legacy SQL, then the queries executed using that view must also be in legacy SQL. The same applies to views that are defined using standard SQL; they can be used only in standard SQL statements. User-defined functions cannot be used in the query to define the views.

The BigQuery web console provides an option to save a query as a view, as shown in the following screenshot. Click on the Save View button as shown in this screenshot and choose the dataset under which the ...