[ WebToolTip.com ] Udemy - Build the Perfect Data Stack for Analytics Engineering

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - The Modern Data Stack From Business Need to Command-Line Execution/1 - Introduction.mp4

29 MB

~Get Your Files Here !/1 - The Modern Data Stack From Business Need to Command-Line Execution/2 - Understanding DBT Core Concepts Through a Practical Example.mp4

31 MB

~Get Your Files Here !/1 - The Modern Data Stack From Business Need to Command-Line Execution/3 - Running DBT Models Command-Line Execution and Dependencies.mp4

45 MB

~Get Your Files Here !/10 - Query Cost Monitoring and Attribution/1 - Cost Monitoring Fundamentals Tracking Query Expenses.mp4

104 MB

~Get Your Files Here !/10 - Query Cost Monitoring and Attribution/2 - Implementing default SQL Headers with +sql_header.mp4

30 MB

~Get Your Files Here !/10 - Query Cost Monitoring and Attribution/3 - Complete Cost Tracking Using query_comment() for All DBT Operations - part_15__cost_5__bq_query.sql

1.2 kB

~Get Your Files Here !/10 - Query Cost Monitoring and Attribution/3 - Complete Cost Tracking Using query_comment() for All DBT Operations - part_15__cost_5__query_comment.sql

1.6 kB

~Get Your Files Here !/10 - Query Cost Monitoring and Attribution/3 - Complete Cost Tracking Using query_comment() for All DBT Operations.mp4

80 MB

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/1 - Incremental Models Efficient Data Updates with insert_overwrite Strategy.mp4

85 MB

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/2 - Optimizing PR Job Costs Preventing Full Refreshes in CI.mp4

98 MB

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_11__default_incremental_filter.sql

578 B

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_12__revenue_daily.sql

1.7 kB

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_13__dbt_project.yml

322 B

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy - part_16__incremental_9__check_table_exists.sql

772 B

~Get Your Files Here !/11 - Incremental Models Optimization, Cost Control, and Schema Management/3 - Managing Schema Changes in Incremental Models Dev vs Prod Strategy.mp4

92 MB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/1 - Introduction to DBT Tests Basic Tests in .yml Files.mp4

82 MB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/2 - Custom Testing Example for Validating End-to-End Data Integrity - part_17__tests_4__data_tests.yml

940 B

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/2 - Custom Testing Example for Validating End-to-End Data Integrity - part_17__tests_4__test_date_equality_filtered.sql

2.0 kB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/2 - Custom Testing Example for Validating End-to-End Data Integrity.mp4

97 MB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/3 - Automated Test Fix Self-Healing Data Pipelines - part_17__tests_5__list_dates_to_retry.sql

1.2 kB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/3 - Automated Test Fix Self-Healing Data Pipelines - part_17__tests_5__run_test_data_pipeline_daily_retry.py

4.4 kB

~Get Your Files Here !/12 - Data Quality Testing From Basic Validation to Automated Fix/3 - Automated Test Fix Self-Healing Data Pipelines.mp4

52 MB

~Get Your Files Here !/13 - More DBT Features Seeds, Macros, and Snapshots/1 - DBT Seeds Managing Static Reference Data with CSV Files.mp4

129 MB

~Get Your Files Here !/13 - More DBT Features Seeds, Macros, and Snapshots/2 - DBT Macros Creating Reusable SQL Logic.mp4

84 MB

~Get Your Files Here !/13 - More DBT Features Seeds, Macros, and Snapshots/3 - DBT Snapshots Tracking Historical Changes with Changing Dimensions - part_20__snapshots__snapshot_stg_customers.sql

416 B

~Get Your Files Here !/13 - More DBT Features Seeds, Macros, and Snapshots/3 - DBT Snapshots Tracking Historical Changes with Changing Dimensions.mp4

72 MB

~Get Your Files Here !/14 - Conclusion My Secrets/1 - Analytics Engineering Fundamentals Principles for Long-Term Success.mp4

93 MB

~Get Your Files Here !/2 - How to set up your DBT project/1 - DBT init.mp4

64 MB

~Get Your Files Here !/2 - How to set up your DBT project/2 - Configuring Development and Production Environments in profiles.yml.mp4

49 MB

~Get Your Files Here !/2 - How to set up your DBT project/3 - Securing Credentials Moving Service Account Keys Outside Your Project - part_3_dbt_profiles_3__README.md

1.4 kB

~Get Your Files Here !/2 - How to set up your DBT project/3 - Securing Credentials Moving Service Account Keys Outside Your Project - part_3_dbt_profiles_3__profiles.yml

651 B

~Get Your Files Here !/2 - How to set up your DBT project/3 - Securing Credentials Moving Service Account Keys Outside Your Project.mp4

48 MB

~Get Your Files Here !/3 - Setting Up Git for Collaborative DBT Development/1 - Version Control Setup Configuring .gitignore for DBT Projects.mp4

23 MB

~Get Your Files Here !/3 - Setting Up Git for Collaborative DBT Development/2 - Initializing Git and Pushing Your DBT Project to GitHub.mp4

24 MB

~Get Your Files Here !/3 - Setting Up Git for Collaborative DBT Development/3 - Testing Your Git Workflow Creating Your First Pull Request.mp4

18 MB

~Get Your Files Here !/4 - Environment Management with UV/1 - Initializing UV Why Isolated Environments Matter.mp4

33 MB

~Get Your Files Here !/4 - Environment Management with UV/2 - Committing UV Configuration Files.mp4

11 MB

~Get Your Files Here !/4 - Environment Management with UV/3 - Documenting UV Setup in README - part_5__uv_setup_4__README.md

1.1 kB

~Get Your Files Here !/4 - Environment Management with UV/3 - Documenting UV Setup in README.mp4

12 MB

~Get Your Files Here !/5 - How DBT Compilation and Packages Work/1 - Understanding dbt_project.yml Configuration and Compilation.mp4

71 MB

~Get Your Files Here !/5 - How DBT Compilation and Packages Work/2 - Installing DBT Packages Adding dbt_utils.mp4

22 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/1 - Staging Layer Conventions and Best Practices.mp4

33 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/2 - Implementing Staging Models Sources, Files, and Configuration - part_8__model_2_staging_2__src.yml

251 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/2 - Implementing Staging Models Sources, Files, and Configuration.mp4

97 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/3 - Intermediate Layer Conventions and Best Practices.mp4

69 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/4 - Implementing Intermediate Models Dimensions, Facts and Naming Convention.mp4

58 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/5 - Introduction to Data Modeling Layers.mp4

41 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/6 - Mart Layer Conventions and Best Practices.mp4

29 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/7 - Implementing Mart Models Final Tables for Analysis and External Tools.mp4

50 MB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__README.md

6.1 kB

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__dim_customer.sql

168 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__ext_salesforce_customer.sql

156 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__fct_revenue_daily.sql

311 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__fct_revenue_event.sql

626 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__revenue_daily.sql

175 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__stg_gsheet_raw_data_customers.sql

210 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards - part_8__model_6__stg_gsheet_raw_data_purchases.sql

275 B

~Get Your Files Here !/6 - Data Modeling Layers Staging, Intermediate, and Mart/8 - Global Conventions SQL Structure and Naming Standards.mp4

112 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/1 - Showcasing Data Usage with Exposures - part_9__exposures.yml

776 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/1 - Showcasing Data Usage with Exposures.mp4

32 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff.yml

702 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff__dbt_utils.py

64 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/2 - Code Quality with SQLFluff Automated SQL Linting - part_10__sqlfluff__settings.json

336 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/2 - Code Quality with SQLFluff Automated SQL Linting.mp4

79 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__fct_revenue_daily.sql

972 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__macros.sql

342 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/3 - Handling SQLFluff Macro Conflicts Advanced Configuration - part_10__sqlfluff_2__sqlfluff.y

935 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/3 - Handling SQLFluff Macro Conflicts Advanced Configuration.mp4

99 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/4 - Model Documentation with YAML File Generation - part_11__documentation__generate_model_yaml.py

10 kB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/4 - Model Documentation with YAML File Generation - part_11__documentation__generate_model_yaml.sql

1.6 kB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/4 - Model Documentation with YAML File Generation.mp4

80 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/5 - Enforcing Code Quality with Pre-Commit Hooks SQLFluff Integration.mp4

31 MB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__README.md

91 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre-commit-config.yaml

952 B

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre_commit_run_documentation.py

4.4 kB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting - part_12__pre_commit__pre_commit_run_model.py

6.0 kB

~Get Your Files Here !/7 - Code Quality and Documentation Automation and Best Practices/6 - Enforcing Code Quality with Pre-Commit Hooks Testing and Documenting.mp4

63 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/1 - Introduction to DBT Cloud Setup and Data Warehouse Connection.mp4

29 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/2 - Connecting Your GitHub Repository to DBT Cloud.mp4

16 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/3 - Creating Production Jobs Scheduling Automated DBT Runs.mp4

35 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/4 - CI Jobs with DBT Cloud.mp4

56 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/5 - Merge Jobs with DBT Cloud.mp4

26 MB

~Get Your Files Here !/8 - Production Deployment with DBT Cloud/6 - Generating and Hosting Documentation with DBT Cloud.mp4

28 MB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/1 - Local Automation with Makefiles SQLFluff Fix - part_14__auto_1_sqlfluff_1__make_sqlfluff_fix.py

3.9 kB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/1 - Local Automation with Makefiles SQLFluff Fix.mp4

61 MB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/2 - Fully Automated SQLFluff Fixes with GitHub Actions - part_14_auto_1__sqlfluff_fix.yml

547 B

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/2 - Fully Automated SQLFluff Fixes with GitHub Actions.mp4

44 MB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/3 - Fully Automated Documentation of Production Models.mp4

74 MB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__cleaning_recommendation.yml

1013 B

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__list_tables_in_prod.sql

1.5 kB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__make_cleaning_reco.py

5.1 kB

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations - part_14__auto_3__makefile.part-14-auto-3-makefile

337 B

~Get Your Files Here !/9 - Workflow Automation Makefiles and GitHub Actions/4 - Production Data Cleanup Automated Table Inventory and Deletion Recommendations.mp4

71 MB

~Get Your Files Here !/Bonus Resources.txt

70 B