Secure data sharing basics in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is secure data sharing in Snowflake?

Secure data sharing in Snowflake allows you to share live data with other Snowflake accounts without copying or moving the data. It keeps data safe and up-to-date.

beginner

What is a 'share' in Snowflake?

A 'share' is an object that contains the database objects you want to share, like tables or views. It controls what data others can see.

intermediate

How does Snowflake ensure data security during sharing?

Snowflake uses access controls and encryption. The data is never copied; only authorized accounts can query the shared data securely.

beginner

What is a 'consumer' in Snowflake data sharing?

A consumer is the Snowflake account that receives and accesses the shared data. They can query the data but cannot change the original data.

intermediate

Why is no data copying important in Snowflake data sharing?

No data copying means data is always current and secure. It saves storage and avoids delays or errors from copying data.

What does a Snowflake 'share' contain?

A Database objects like tables and views

B User passwords

C Physical copies of data

D Network settings

A 'share' contains database objects such as tables and views to share with other accounts.

Who can access data in a Snowflake share?

A Only the data owner

B Any internet user

C Only authorized Snowflake consumer accounts

D Anyone with a Snowflake account

Only authorized consumer accounts granted access can query the shared data.

What happens to the data when shared in Snowflake?

A It remains in the provider's account and is accessed live

B It is moved to a new database

C It is copied to the consumer's account

D It is deleted from the provider's account

Data remains in the provider's account and consumers access it live without copying.

What is a key benefit of Snowflake's secure data sharing?

A Data is always outdated

B Data is copied multiple times

C Data is publicly accessible

D Data is live and secure without duplication

Data sharing is live and secure without creating copies, ensuring up-to-date data.

Can a consumer modify the shared data in Snowflake?

A Yes, they can edit the original data

B No, they can only query the data

C Yes, but only if given special permission

D No, they cannot see the data

Consumers can query but cannot modify the original shared data.

Explain how Snowflake's secure data sharing works and why it is beneficial.

Think about how sharing without copying helps keep data fresh and safe.

Describe the roles of 'share' and 'consumer' in Snowflake data sharing.

Consider who provides data and who uses it.