Snowflake Database - The Modern Data Lake

Name: Snowflake Database - The Modern Data Lake
Rating: 4.3 (57 reviews)

See how Snowflake can become your new modern data lake along with your data warehouse and everything else

Created byRandy Minder

Last updated 5/2021

English

What you'll learn

How Snowflake Can Replace the Traditional Data Lake
How Snowflake Can Supplement the Traditional Data Lake
How Snowflake Can Act as a Query Engine for Your Data Lake
History of Data Lakes
Data Lake vs. Data Warehouse
How Data Lakes Become Data Swamps
Case Studies of Companies Making the Transition from Data Lakes to Snowflake

Course content

6 sections • 21 lectures • 3h 28m total length

Introduction1:40
Course introduction

Overview5:19
In this lecture we cover a high-level overview of data lakes
History of the Data Lake12:42
In this lecture we talk about this history of the data lake
The Problems (Hadoop)10:17
In this lecture we talk about the problems with traditional data lakes and the role Hadoop has played in this.
Data Lakes and Data Warehouses9:32
The Data Swamp9:30
Here we discuss how data lakes become data swamps

A Better Approach - Overview9:17
In this lecture we give a high-level overview of the cloud data platform. A better approach to the traditional data lake.
Steps to Implementing11:34
In this lecture we discuss the things to consider when implementing a cloud data platform.
Introducing Snowflake6:55
In this lecture we introduce Snowflake and your single, unified, cloud data platform
Snowflake Overview8:21
This is the Snowflake Overview lecture from our Snowflake Database - The Complete Cloud Data Platform course. There will be some overlap of what we've already discussed. But it does a good job providing a thorough overview of Snowflake. It's important to have this overview before we move on to more a more detailed discussion of Snowflake as a data lake. If you've already taken The Complete Data Platform course, you can skip this lecture.
Snowflake High-level Architecture11:24
This is the Snowflake high-level architecture lecture from our Snowflake Database - The Complete Cloud Data Platform course. There will be some overlap of what we've already discussed. But, it does a good job providing a thorough architecture of Snowflake. It's important to have this knowledge before we move on to more a more detailed discussion of Snowflake as a data lake. If you've already taken The Complete Data Platform course, you can skip this lecture.
Creating a Demo Snowflake Account1:15
In order to follow along with the rest of this course, you will want to get a demo Snowflake account, if you do not already have one. This lecture shows how to get one.
The Snowflake Web UI14:22
This is the Snowflake Web UI lecture from our Snowflake Database - The Complete Cloud Data Platform course. If you have already taken the course, you can skip this lecture. If not, and you want to follow along as we show, in later lectures, how to use Snowflake as a data lake, you will want to be familiar with the Snowflake Web UI.

Snowflake vs Data Lakes - A Comparison8:37
A very interesting comparison between traditional data lakes vs. Snowflake as a data lake
Traditional Data Lake Architecture11:01
In this lecture we discuss the traditional and commonly used data lake architecture
Snowflake Data Lake Architecture16:16
In this lecture we discuss the Snowflake data lake architecture
Snowflake Data Lake Demo16:52
In this lecture we demonstrate how to access data lake files sitting in Azure inside Snowflake and the creation of materialized views

Requirements

Some basic knowledge of Snowflake would be useful

Description

The failure rate on big data traditional data lake projects is between 60% and 80%. Hadoop was billed as the platform to store and analyze data. It promised to minimize data silos with the concept of a Data Lake. But, Hadoop has largely failed in its ability to consider the operational side of data and what it takes to actually run a business. Big data systems like Hadoop are complex and require teams of expensive engineers to build and maintain them. This course shows how Snowflake changes all this. Snowflake is the complete modern cloud based data platform that can integrate with, or completely replace your data lake. This course shows how this is made possible.

We do an in-depth discussion of the history of data lakes and the architecture of the modern on-premises or cloud-based data lake. We talk about what's good about data lakes and what's bad about them. We talk about data lakes becoming data swamps. Most importantly, we discuss how Snowflake can completely replace the traditional data lake and be your single repository for corporate data.

Finally we present three case studies of companies that tried to make the traditional on-premises (or cloud-based) data lake architecture work for them and finally scrapped it and settled on Snowflake.

We wrap up the course with some questions to test your knowledge of the material.

Who this course is for:

Snowflake developers, Snowflake Architects and Snowflake Administrators

Snowflake Database - The Modern Data Lake

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Traditional Data Lakes5 lectures • 47min

The Cloud Data Platform7 lectures • 1hr 3min

Snowflake Database as a Data Lake4 lectures • 53min

Case Studies3 lectures • 36min

Time to Test Your Knowledge1 lecture • 8min

Requirements

Description

Who this course is for: