Dataset

Create dataset Alter schema set options Drop dataset

Tables

Create table Create table as select Create table like Create table copy Create table options Create external table Create temp table Alter column drop not null Alter column set options Alter column change datatype Alter table set options Alter table rename Alter table add column Alter table drop column Drop temp table Drop table Drop external table

Snapshot Tables

Create Snapshot table List of snapshots Restore snapshot table Copy to Snapshot table Drop snapshot table

Views

Create view Create Materialized view Alter view set options Alter materialized view options Drop view Drop materialized view

Routines

Create Stored Procedure Create Function Create row access policy Create table function Drop function Drop table function Drop Procedure Drop row access policy

DML

INSERT values INSERT from a table INSERT values with subquery UPDATE statement UPDATE from table MERGE Statement DELETE statement TRUNCATE table

Home » Bigquery » Tutorials » Alter materialized view options

BigQuery Alter materialized view set options

Set options on materialized view

Alter materialized view options example

ALTER MATERIALIZED VIEW mydataset.my_mv
SET OPTIONS (
  enable_refresh=true,
  refresh_interval_minutes=20
)

Explanation

IF EXISTS: If no dataset exists with that name, the statement has no effect.
dataset_name: The name of the dataset to delete.
CASCADE: Deletes the dataset and all resources within the dataset, such as tables, views, and functions. You must have permission to delete the resources, or else the statement returns an error
RESTRICT: Deletes the dataset only if it's empty. Otherwise, returns an error. If you don't specify either CASCADE or RESTRICT, then the default behavior is RESTRICT

Syntax reference

ALTER MATERIALIZED VIEW [IF EXISTS] materialized_view_name
SET OPTIONS(materialized_view_set_options_list)