From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 24,400 courses taught by industry experts.
Querying regular views and secure views - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Querying regular views and secure views
- So far, the views that we've worked with have been regular views. With regular views the underlying query associated with the views executed each time you query the view. Materialized views are different, but before we understand materialized views let's look at the query profile of a query that we run on a regular view. I have a query here on line 17 and 18. Select star from order summary where broad name like S percent products that start with S. I'm going to run this query. I get the query results. I'm not interested in the query results. Instead, I'm going to click on the three dots that you see over at the bottom, right? This will bring up a little pop up on snow sight which you can use to copy your query ID or view query profile. View query profile is what I'm interested in. Clicking on this. It'll open up a new browser tab and you can see that the query profile gives you a flow chart of the different…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
