From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Set up base table for query optimization comparisons

Set up base table for query optimization comparisons - Snowflake Tutorial

From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Start my 1-month free trial Buy for my team

Set up base table for query optimization comparisons

“

There are two more optimization techniques that we still have to cover. This is going to be clustering and search optimization. What I'm going to do for these techniques is compare the performance of our clustered and search optimized table against a base table. And we'll first set up the base table here in this video. I'll set up the base table from the sales analytics table that we had created in an earlier demo. And I'm going to copy data into this table using a larger warehouse so that the copy runs through faster. I create a new warehouse called LargeWH, and you can see the warehouse size is large. Set up AutoSuspend and AutoResume. I'll use this large warehouse for the data copy operation. I'm going to create a new table with a subset of data from the original sales analytics table. This new table will contain about 50 GB of data. And of course, we'll create it within the test database. I'll just verify that we still have the sales analytics table that we had set up earlier…

Contents