Skip to content

Instantly share code, notes, and snippets.

@latestalexey

latestalexey/dbt_users_workshop.md

Forked from nikb-de/dbt_users_workshop.md
Created December 12, 2022 17:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save latestalexey/5f5928e5c7cdca1c47dfe3cbcf32f835 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save latestalexey/5f5928e5c7cdca1c47dfe3cbcf32f835 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @nikb-de nikb-de created this gist Sep 11, 2022.
    39 changes: 39 additions & 0 deletions dbt_users_workshop.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,39 @@
    # 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