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 Alter column drop not null Create temp table 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 » INSERT values with subquery