Home  >  Blog  >   Snowflake  > 

How to Create a View in Snowflake

In Snowflake, we create views for securing the files and set access restrictions to the files. This blog discusses creating views for different purposes.

Rating: 4.5
  
 
521
  1. Share:
Snowflake Articles

Create a View in Snowflake

Views are created using the “CREATE VIEW” and “SELECT” commands. We can create the views whenever we require. In this blog, you will learn to create views. 

Views allow you to bind or hide the difficulties or enable restricted access to a little bit of data.

For creating a view, we use the “CREATE VIEW” command:

create view view_name
as select_statement;

Example:

create view category1_2_products1_u as
select *
from products1
Where category1 = 2;
Looking forward to a career in a cloud data warehousing domain? Check out the "Snowflake Training" and get certified today

View to restrict read access to only particular columns:

Create view category_products_basic_u as
select
category1,
name1,
unit_price1
from products1


A View that displays the top 12 products that offer the highest sold value:

create view top_12_product1_v as
select
top 12 p1.name1,
p1.category1,
p1.unit_price1,
ps1.quantity_sold1,
p1.unit_price1 * ps1.quantity_sold1 as sold_value1
from product1 p1
left join products_sold1 ps1 on p1.id = ps1.product_id
order by sold_value1 desc;

 MindMajix YouTube Channel

Conclusion

We create views for displaying the chosen columns and rows in multiple tables. I hope this information is adequate for working with views.

Snowflake Related Articles


▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop
▶  Snowflake Time Travel

Join our newsletter
inbox

Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!

Course Schedule
NameDates
Snowflake TrainingApr 01 to Apr 16
Snowflake TrainingApr 04 to Apr 19
Snowflake TrainingApr 08 to Apr 23
Snowflake TrainingApr 11 to Apr 26
Last updated: 30 March 2023
About Author
Remy Sharp
Viswanath V S

Viswanath is a passionate content writer of Mindmajix. He has expertise in Trending Domains like Data Science, Artificial Intelligence, Machine Learning, Blockchain, etc. His articles help the learners to get insights about the Domain. You can reach him on Linkedin

Recommended Courses

1 /10