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