Following are the different types of tables available in Snowflake :
Permanent : It is a typical database table. It utilizes more space, and we can enable fail-safe and Time-travel periods. Permanent tables are useful for the data that requires a higher level of data recovery and data protection.
Transient : In Snowflake, we can create transient tables that exist until externally dropped and are accessible to all the users with relevant privileges.
Temporary : We use the temporary table to store transitory and non-permanent data. Temporary tables exist only in the session in which they were developed.
External : External tables are read-only, and we cannot perform DML operations on them. We can use external tables for join and query operations.
