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 ;
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