Query Caching Performance Features with Snowflake

Focused View

Rushabh Doshi

35:01

68 View

1. Course Overview

1. Course Overview.mp4

01:12

2. Initiating Snowflake Environment Setup

1. Introduction to Snowflake Architecture.mp4

02:30

2. Snowflake Life Cycle.mp4

01:50

3. Demo - Initiating Snowflake Environment.mp4

02:33

4. Demo - Initiate a Virtual Warehouse and Load the Dataset.mp4

06:39

5. Summary.mp4

00:34

3. Understanding the Snowflake Caching Architecture

1. Introduction to Performance Optimization.mp4

01:51

2. Introduction to Micro Partitions.mp4

02:03

3. Importance of Caching and Clustering.mp4

02:09

4. Summary.mp4

00:45

4. Evaluating Query Caching Performance in Snowflake

1. Introduction to Dedicated Virtual Warehouse.mp4

01:35

2. Demo - Implement Dedicated Virtual Warehouse.mp4

03:28

3. Demo - Implement Caching.mp4

03:53

4. Demo - Implement Clustering.mp4

03:19

5. Summary.mp4

00:40

Description

This course will teach you the end-to-end Snowflake architecture and how it addresses the needs for different data processing, storing, and analytics requirements.

What You'll Learn?

Data querying needs have evolved as organizations have acquired structured and unstructured data. In this course, Query Caching Performance Features with Snowflake, you’ll learn to evaluate multiple data and querying needs of an organization. First, you’ll explore the end-to-end Snowflake architecture. Next, you’ll discover different components of Snowflake. Finally, you’ll learn how to master the caching mechanism to answer the query with results in no time without any latency. When you’re finished with this course, you’ll have the skills and knowledge of caching architecture in Snowflake needed to drive down latency for efficient querying.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Analysis

Database Design

Rushabh Doshi

Instructor's Courses

Rushabh Doshi is an Artificial Intelligence/AWS/Azure/GCP cloud architect with extensive experience in DevOps, NoSQL Databases like MongoDB, Cassandra.He is an orator/speaker/tech evangelist, have participated in several tech events/seminars, conducted trainings across Europe/US and Asia Pac.He is one of the first few certified cloudera big data professional with extensive experience in Apache Flink, Spark, Hadoop and ELK stack. He has over 14 years of consulting, training, designing and architecting experience taking the product from concept to production.Had worked with tech giants like CISCO, EY, ERICSSON, WIPRO and CAPCO.He enjoys nature trek, wild life and cycling. He is full of positive attitude with excellent communication skills.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.