Snowflake 101 – Build & Design Data pipelines on AWS Cloud

سرفصل های دوره

Snowflake & AWS Cloud for Beginners: Data Engineering and Pipeline Architecture Basics with practical hands on labs

1 - Introduction

1 - Introduction to Snowflake

2 - Snowflake Architecture

3 - Demo Setting Up Snowflake Account

2 - Snowflake Tables

4 - Types of Tables

5 - Demo Creating Tables in Snowflake

3 - Snowflake Views

6 - Types of Views

7 - Demo Creating Views in Snowflake

4 - Partitioning and Clustering

8 - Creating Micropartitions And Clustering Keys

5 - Data Loading Ingestion and Extraction

9 - Creating an Integration Object to Connect Snowflake with AWS S3

10 - Ingesting CSV from S3 to Snowflake

10 - load-csv-into-sf.zip

11 - Ingesting JSON from S3 to Snowflake

11 - load-json-into-sf.zip

6 - Roles in Snowflake

12 - Creating roles and granting access

7 - Streams in Snowflake

13 - Introduction to Streams

14 - Demo Implementing Standard Streams

14 - append-only-streams.zip

15 - Demo Implementing AppendOnly Streams

15 - standard-delta-streams.zip

8 - Snowflake with Python and AWS Glue

16 - Connecting Python with Snowflake on Your Local Machine

16 - snowflake-connector-python-2.3.8-py3-none-any.zip

17 - Deployment and Execution of Python Script on AWS Glue

18 - Parameterizing Your Python Script on AWS Glue

18 - glue-python-params.zip

19 - Python Pandas with Snowflake on AWS Glue

19 - main.zip

9 - Instantaneous data streaming Kafka with Snowflake

20 - Setting Up Kafka on Local Machine

20 - connect-standalone.zip

21 - Setting up Kafka Snowflake Connector

21 - connect-standalone.zip

21 - sf-connect.zip

22 - Setting Up Encryption Keys

22 - connect-standalone.zip

22 - sf-connect.zip

23 - Realtime Data Streaming with Kafka

10 - Snowflake Zero Copy Cloning

24 - Zero Copy Cloning in Snowflake

25 - Clone VS Snapshot

26 - Schema level cloneable Objects in Snowflake

27 - Demo Simple Table Cloning

28 - Demo Transient and temporary table cloning

29 - Demo Object Dependency with clone

30 - Demo Clone File Formats and sequences

31 - Demo Clone Stream Objects

11 - Snowflake Snowsight

32 - Creating Dashboard using Snowsight

33 - Dashboard Filters

34 - Dashboard for Covid19 dataset

12 - Time Travel in Snowflake

35 - What is Time Travel

36 - Time Travel vs FailSafe

37 - Demo How to enable Time travel

38 - Demo Drop Undrop table schema and database

39 - Demo Clone with Time Travel

13 - Tasks in Snowflake

40 - Creating Standalone and Dependent Tree of Tasks

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy