Skip to content

Instantly share code, notes, and snippets.

@latestalexey
Forked from nikb-de/dbt_users_workshop.md
Created December 12, 2022 17:29
Show Gist options
  • Save latestalexey/5f5928e5c7cdca1c47dfe3cbcf32f835 to your computer and use it in GitHub Desktop.
Save latestalexey/5f5928e5c7cdca1c47dfe3cbcf32f835 to your computer and use it in GitHub Desktop.

1 dbt basics

  • dbt core architecture
  • profiles.yaml, sources.yaml, Настройка коннектора
  • dbt compile
  • dbt run
  • dbt docs
  • dbt_utils

2 dbt advanced

  • snapshot
  • exposures
  • built-in materializations
  • source freshness
  • using extensions
  • manifest.json
  • macros basics

3 dbt tests & hooks & cloud

  • Hooks & Operations
  • dbt tests: basic, custom, generalised
  • Переписываем базовые тесты
  • dbt_expectations
  • Dbt cloud - функционал

4 Data Vault 2.0 & dbt

  • Data Platform Architecture
  • Data Vault 2.0 modeling
  • dbtvault usage

5 Metrics & dbt modules extension

  • dbt metrics
  • Пишем свой модуль и разбираемся как все устроено

6 Infra & dbt

  • CI/CD & dbt
  • dbt & data catalog
  • Airflow & dbt
  • Dev & Testing environment
  • Manifest, Artifacts, Monitoring
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment