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

Convert DELETE statements from Teradata to BigQuery - Migration Guide

For data protection, BigQuery requires all DELETE queries to have a WHERE clause

TeradataBigQuery Equivalent

DELETE t1 ALL;

DELETE FROM t1 WHERE TRUE;

DELETE FROM t1;

DELETE FROM t1 WHERE TRUE;

TRUNCATE TABLE t1;TRUNCATE TABLE t1;
TRUNCATE table is efficient than DELETE when using deleting all the rows in a table