Рет қаралды 586
THE FUTURE OF SNOWFLAKE WITH DBT DEMO
THE FUTURE OF SNOWFLAKE
SNOWSQL (SQL)
SNOWFLAKE
AWS S3
MICROSOFT AZURE BULB
GCP
ADDED ADVANTAGE SKILLS
DBT
ETL TOOLS
PYTHON
PYSPARK
JAVA
SCALA
JAVA SCRIPT
TABLEAU
1.COMMANDS
2.FILTERING AND SORTING
3.STRING FUNCTIONS
4.NUMBER AND DATE FUNCTIONS
5.CTAS & SET OPERATORS & CASE AND DECODE
6.NULLS
7.Aggregate functions & ANALYTICAL FUNCTIONS
8.CONSTRAINTS & JOINS
9.PIVOT AND UNPIVOT & SUBQUERIES
10.INDEXES & VIEWS & PERFORMANCE TUNING
SNOWFLAKE ALL CONCEPTS
TIME TRAVEL
COPY CLONING
UNDROP
DATA LOADING
DATA UNLOADING
VIEWS
Etc.......
1. Introduction
2. Course roadmap
4. ETL vs. ELT
5. What is DBT?
6. Key categories of features
7. Top Features of DBT
8. Why use DBT? Exploring the Benefits for your Data Workflow
9. What is Analytical Engineering?
10. Ways to reach out
DBT ACCOUNT SETUP
14. Create a Snowflake Account
15. Explore the Snowflake Web UI interface 6MIN
16. Load Sample Data
17. Create a DBT Cloud account
18. Setup the DBT Project
19. Initialize the DBT Project
20. Explore the DBT Cloud Web UI interface
DBT MODELS
21. Explore DBT Project Config file
22. What are DBT models?
23. Introduction to Creating a Simple Model
24. Create Table in DBT
25. What is DBT Schema?
26. Build First DBT Model
27. What is Ref Function in DBT?
28. Best Practices for Organizing Your DBT Project Structure
29. Configuring Materializations in DBT
30. Refactor your dim_customers Model
DBT Tests
31. What is DBT Schema?
32. What is DBT Macro?
33. What is Testing?
34. What is DBT Test?
35. Different Types of Test in DBT
36. What is Generic Test?
37. Writing Generic Tests in DBT
38. Writing Singular Tests in DBT
39. DBT Test Commands: Syntax and Usage
DBT Materializations
40. What are Materializations in DBT?
41. Default Materializations in DBT
42. Using Config Block for Materializations
DBT Seeds and Sources
43. What are Sources?
44. How to Add Sources in DBT?
45. What is DBT Source Freshness?
46. Implementing Source Freshness Checks in DBT
47. What is DBT Seed?
46. Implementing Source Freshness Checks in DBT
47. What is DBT Seed?
48. Implementing DBT Seeds in DBT
DBT CLOUD FEATURES
49. How to Manage Version Control in DBT?
50. How to Setup Monitoring and Alerting in DBT?
51. How to Schedule DBT Runs and Automate Data
DBT JINJA AND DOCS
52. Introduction to Jinja
53. What are DBT Docs?
DBT Load and Custom Macros
54. Implementing Table, View and Ephemeral Model
55. Implementing Incremental Load in DBT
56. Create Custom Macros
57. What is DBT Packages?
DBT Snapshots
58. What are Snapshots in DBT?
59. Implementing Snapshots in DBT
DBT Hooks
60. What are Hooks in DBT?
61. Implementing Hooks in DBT
DBT Analyses
62. What is Analyses?
63. Implementing Analyses in DBT
64. Tuning DBT Project