Architecture Overview Flashcards
Supported Data Types in Snowflake
Most basic SQL data types
Cloning in Snowflake
Cloning in Snowflake is a relatively unique feature to Snowflake. This allows for direct replication of an object.
What objects can be cloned in Snowflake?
- Databases
- Schemas
- Non-temporary tables
Cloned Object inheritance
Cloned Objects inherit the parameter values set at the account level by default, but can be overwritten by individual objects.
Do changes made to the source of a clone flow over to the clone?
No
Requirements to create a clone tables?
You must have SELECT access to that table.
Requirements to create clones for pipes, streams, or tasks?
OWNERSHIP access on the object.
Requirements to create a clone for remaining objects? (excluding table, pipes, streams, and tasks)
USAGE
Does a clone contribute to overall data storage costs?
Only after the clone has been modified from its source.
Secure Data Sharing
Enables selected objects in a database within your account to be shared with other Snowflake accounts.
Objects that can be shared with Secure Data Sharing
- Tables
- External Tables
- Secure Views
- Secure Materialized Views
- Secure UDFs
Access Writes on shared database objects?
Read-only
Are there any limits on the shares you can export/import as a provider/consumer?
No
Is any data copied with Secure Data Sharing?
No, all sharing is accomplished through Snowflake’s Cloud Services Layer, so shared data does not take up any storage in the consumers account.
Shares
Snowflake enables the sharing of databases through shares, which are created by data providers and imported by consumers.
Shares are named objects that encapsulate all the information required to share a database.