29 Jan 21 ·  Cpaul in Guides ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Convert INSERT statements from Teradata to BigQuery - Migration Guide

Teradata insert statement syntax is supported in BigQuery without any changes.

INSERT INTO t1 (colname) VALUES ('abc');
INSERT INTO t1 (colname) VALUES ('xyz');

You can also convert the above series of insert statements from Teradata into one Bulk insert in BigQuery for efficiency

INSERT INTO t1 VALUES ('abc'), ('xyz');