From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Join today to access over 24,400 courses taught by industry experts.
Creating and querying materialized views - Snowflake Tutorial
From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics
Creating and querying materialized views
- [Instructor] In this demo, we'll create a view by using one of Snowflake's sample tables as the underlying base table. The table that we are working with is in the snowflake sample data database. It's in the schema called TPCH, underscore SF 10 and the table is called LINEITEM. I'm going to create a table called line item in my current database, eCommerce DV, the public schema. And we'll use the data in this table as the basis for our view. Now, the reason I've chosen this particular table is that it's fairly large. It has 1.6 gigabyte worth of data. If you want to see a sample of what this data looks like run a simple select star operation and you can see that this is artificially generated data. So there is lots of data here. You can take a look at all of the columns. The data here is not important. It's important to know that the size of this table is now 1.5 gigs. I'm now going to create two different views…
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.
