1
COURSE TO JOB TRAININGS
SNOWFLAKE + DBT (DATA BUILD TOOL) COURSE
CONTENT
+91-7993454547 www.coursetojob.com Coursetojob1983@gmail.com
SNOWFLAKE - DBT COURSE CONTENT
1. Overview
Snowflake History
Introduction to Snowflake
Architecture of Snowflake (Services Layer, Compute Layer, Storage Layer)
Snowflake Registration
SnowSQL
Setting up the Config file
2. Compute Layer/Virtual Warehouse
Introduction to Compute Layer
Introduction to the Virtual Warehouses
3. Staging in Snowflake
Types of Staging (Internal, External)
Internal Stage (User Stage, Table Stage, Named Stage)
Loading the data into Different Stages
Loading multiple files into User Stage by creating a folder using regular expressions
Listing the stages (User, Table, Named)
Creating a Snowflake Managed Internal Stage
Loading the data into the internal stage
4. External Stages, AWS External Stage
Introduction to the external stage
Explanation on AWS Console.
Examples on S3 Service in AWS
Create a Bucket, User, Folder, Role, Policy in AWS
Upload the files and list all the files in SF
5. Copy Command
Options available in Copy Into command
Introduction of loading the data in the snowflake
loading a single file into a table
loading the selected files into a table
6. Tables in Snowflake
Introduction of Tables
Different type of the tables and differences
Design Considerations based on the environment
Introduction to Data Retention Policy
7. Snowpipe
Introduction to the Snowpipe
Create a bucket and Folder in AWS
2
Creating a Role for Snowpipe
S3 Policy Assignment to the Role
Creating the Staging, Integration, pipe, Event configuration, Notification in AWS
Creating the Storage Account, Container, Queue, Event, Notification, Pipe in Azure
Creating the Bucket, Folder, Storage Integration Object, External storage in Google
Cloud
8. Time Travel
Introduction of Time Travel
Data Life Cycle and Time Travel operations
Time Travel SQL Extensions, Parameters, Offset
Timestamp, Statement, Un Drop
Retrieving the Historical Data
9. Cloning
Introduction of Cloning
Cloning of Tables
Cloning Database and Schemas
Discussing Fail Safe
Querying the Space for Table, Time Travel and Fail Safe
10. Streams
Introduction to the streams
Creating and identifying the key Aspects of Stream
METADATA$ACTION, METADATA$UPDATE, METADATA$ROW_ID
Load the Data into the Target Table
Insert, Update, Delete - Related to stage Table data
11. Tasks
Introduction to the Tasks
Introduction to the Schedules in Tasks
Create a Task (Stand Alone Task)
Create a dependent, Parent, Child tasks
Order of resuming and suspending the tasks.
Scheduling the Tasks
12. Caching
Introduction to caching
Types of Cache
Clustering in Snowflake
13. Data Sharing
Introduction to Data Sharing, Reader Account
Inbound and Outbound Shares
Data Sharing with External snowflake Accounts
Data Market Place (Inbound, Outbound)
14. Roles in Snowflake
Introduction to Pre-Defined Roles
Introduction to Custom Roles
Creating Users, Custom Roles
Understanding about Privileges
15. Functions and Stored Procedures
Introduction to the Functions
Introduction to Stored Procedures
16. Materialized Views, External Tables
Introduction of Materialized Views
Refreshing the MVIEWS
Create and Query the Data from the External Tables
Querying JSON Data.
17. Python Connectors
Introduction on how to communicate between Python and Snowflake using connector.
Querying the table from Python.
18. Load data from Oracle to Snowflake using Informatica Cloud
Introduction to Informatica Cloud.
Installation and configuration.
Creating Mappings and Tasks to load the data from Oracle to Snowflake
19. Data Build Tool
Environment Setup
Visual Studio Code
Github repo creation
DBT installation
Create/ Execute first DBT model
Installation and configuration.
20. Snowpark examples
21. DBT Overview
22. Features of DBT
23. DBT core vs DBT Cloud
24. Environment Setup
25. Visual Studio Code
26. Git hub repo creation
27. Snowflake trail account creation
#407, Crescent arcade, Madhapur, Hyderabad
28. DBT installation
29. Create/ Execute of DBT models
30. Analyses
31. Models
32. Macros
33. Seeds
34. Snapshots
35. Tests
36. Deep Dive into Materialization's Theory
37. Seeds and Sources
38. Snapshots
39. Macros
40. Custom Tests
41. Jinja Templates
42. Documentation
43. Lineage Graph
44. Analyses
45. Hook
46. Interview Preparation
47. Project Discussion
48. Resume Preparation.
#407, Crescent arcade, Madhapur, Hyderabad
