Explain about the different table Types available in Snowflake?Snow Flakes interview questions for experienced/Snow Flakes Interview Questions and Answers for Freshers & Experienced

Explain about the different table Types available in Snowflake?

There are four types of tables which can be created in Snowflake

1. Permanent:- It is the regular database table. Consumes space, Time-travel and fail-safe period can be enabled. All tables in snowflake by default are micro-partitioned, compressed, encrypted, and stored in columnar format. Permanent tables are designed for data that requires the highest level of data protection and recovery. The Tables persist until dropped.

2. Temporary:- A temporary table is used for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session. As such, they are not visible to other users or sessions. Once the session ends, data stored in the table is purged completely from the system and, therefore, is not recoverable, either by the user who created the table or Snowflake.

3. Transient:- Snowflake supports creating transient tables that persist until explicitly dropped and are available to all users with the appropriate privileges. Transient tables are similar to permanent tables with the key difference that they do not have a Fail-safe period. As a result, transient tables are specifically designed for transitory data that needs to be maintained beyond each session (in contrast to temporary tables) but does not need the same level of data protection and recovery provided by permanent tables

4. External:- External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

Posted Date:- 2021-10-07 05:48:43