We have recently started working on snowflake. We have a few tables with an identity column in snowflake. These tables are staging tables and We are truncating them in every execution. Recently, We noticed that the identity column does not get reset during truncate.
In some databases, like MS SQL server, identity columns get reset in truncate operation.
My question is, Does the identity column get reset when it reaches the max value?