How to Truncate a table in Google Bigquery

There is no TRUNCATE clause in Bigquery. Use the DELETE statement when you want to Truncate rows from a table like given below:

DELETE FROM dataset.DetailedInventory WHERE true;

or the below command works as well:

DELETE FROM dataset.Inventory WHERE 1 = 1 ;

posted on 08 May 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds