Introduction

Home Comparison

Converting Objects

Table View Stored Procedure Datatypes

Converting SQL

SELECT Statement INSERT Statement UPDATE Statement MERGE Statement DELETE Statement Column Alias QUALIFY Clause

Home » 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

Teradata	BigQuery 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

◀ Previous Tutorial

MERGE Statement

Next Tutorial ▶

Post Comment