Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

How to Truncate a Table in Snowflake in Snowflake

Be super careful with TRUNCATE command. It will empty the content of your Snowflake table. This is useful in development, but you'll seldom want to do this in production.

truncate table_name;

truncate users;

If the table contains an AUTO_INCREMENT column, the counter for it will not get reset. Note that this behavior is different vs some other databases like SQLServer for example, where you don't need to reset the counter yourself.

Ready for a modern SQL editor?