Announcing our $3.4M seed round 🚀 Read more →

How to Create a View in Snowflake in Snowflake

Views let you to encapsulate or “hide” complexities, or allow limited read access to part of the data.

To create a view, use the CREATE VIEW command:

-- syntax
create view view_name
as select_statement;

Some examples: 1. a view to show only products within category 1

create view category_1_products_v as
select *
from products
where category = 1;
  1. a view to limit read access to only certain columns
create view category_products_basic_v as
select 
  name, 
  category, 
  unit_price
from products;
  1. a view that displays top 10 products that provide highest sold value
create view top_10_products_v as
select 
  top 10 p.name, 
  p.category, 
  p.unit_price, 
  ps.quantity_sold, 
  p.unit_price * ps.quantity_sold as sold_value
from products p
left join products_sold ps on p.id = ps.product_id
order by sold_value desc;

Ready for a modern SQL editor?