Secure View &Sharing Data
Sujith Nair
Cloud Data Architect
Snowflake Snowpro Certified
#What is a secure view. Why would you create a secure view ?
Create secure view view_customer as
Select * from customer
Views should be defined as secure when they are specifically needed to limit
access to sensitive information.
What is the difference between a regular view and a secure view ?
• The query used in creation of the secure view is not visible to users(except
owner) providing greater security.
• Regular views are more performant than secure views because
internal optimizations used in regular views are not used in
secure views as they can expose the data through user code
this provides greater data security with the secure view but
reduce view performance
• Secure views can be shared with data sharing, regular
views cannot be shared.
# Have you created a data share and shared data in your project ?
We use data shares to share data between accounts within our own organization.
We also share data with external partners who need access to our data with the help
of data shares.
# What are reader accounts ? Have you created reader
accounts in your project ?
Reader account is snowflakes way of providing data access to users who do not
have a snowflake subscription and do not plan to get one.
Reader accounts enable these users to get setup with snowflake quickly without
having to go thru the process of signing a licensing agreement. The account that
creates the reader account is responsible for providing the compute needed for
the consumption of the data.
The project data architect creates reader accounts for
vendors.
You can see all reader accounts by using the command
SHOW MANAGED ACCOUNTS
#What objects can we share in snowflake?
• Secure View
• Tables
• Secure UDF
• External Tables
Thank you!
Learn2CloudData Solutions
