Using Your BigQuery Environment

BigQuery scripting enables you to send multiple statements to BigQuery in one request, to use variables, and to use control flow statements such as IF and WHILE.

BigQuery scripting feature provides some basic scripting building blocks but it is not adapted for some advanced scripting use cases. For example, table names and column names cannot use variables—although it is possible to store a SQL expression in a string variable and run it with the EXECUTE IMMEDIATE statement.

See Google's instructions.

BigQuery scheduling allows you to set a cadence for recurring queries, such as updating particular tables and views based on refreshes of data from your data sources. For example, you can automatically populate a view based on weekly sales metrics.

See Google's BigQuery scheduling instructions.

You must be assigned the Data Scientist persona to access this feature. Any Data Scientist persona within your tenant account team can create and edit queries within your BigQuery instance. Any queries created by inactive users are still available to other users with the Data Scientist persona.

You can schedule a BigQuery job to update a table you want to save to Customer Profiles and automate the job by specifying ALTER TABLE and SET OPTION to apply the sendtocustomerprofiles label. For example:

ALTER TABLE '<table_name>' SET OPTIONS (labels=[("sendtocustomerprofiles", "ready")])

Where: <table_name> is replaced by the name of your table.

BigQuery ML enables users to create and execute machine learning models in BigQuery using standard SQL queries. That allows data scientists to train, evaluate, and predict a machine learning model on a very large dataset within minutes and from the BigQuery console.

Use the _ai dataset of your tenant for storing the model description and output tables.

Supported Machine Learning algorithms:

For more information, see Google's Introduction to BigQuery ML.

For an overview of BigQuery and its functions, see the following Google articles: