Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?
A Temporary table in Snowflake is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session. These characteristics distinctly match the properties of temporary tables in Snowflake.
Correct
what do you think about this answer ? The correct answer is: D. Transient Here's why: Temporary tables: These tables are visible within the session but cannot have the same name as permanent tables in the same schema. They are dropped automatically at the end of the session. Local tables: This type doesn't exist in Snowflake. There might be confusion with temporary tables, but Snowflake doesn't have a concept of "local" tables. User tables: This concept doesn't exist in Snowflake's table types. Ownership of tables is associated with users, but there's no specific "user" table type. Transient tables: These tables fulfill all the criteria mentioned in the question: Visibility: Only visible to the user who creates them. Naming: Can have the same name as permanent tables within the schema (unlike temporary tables).
https://docs.snowflake.com/en/user-guide/tables-temp-transient