How to Truncate a Table 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.
--syntax 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.