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?
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).
Correct answer is A, Temporary.
As you can read in the documentation:
"Snowflake supports creating temporary tables 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."
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MultiCloudIronMan
1 year, 7 months agoAlex_Ovidiu
7 months, 1 week ago06c63d0
3 months agojtm22
1 year, 7 months ago