dbt（数据构建工具） - 分析工程师的 dbt
- 1. dbt(data build tool) Connections
- 1. dbt Introduction
- 1.1 dbtOverview
- 2. Create a GitHub Repository
- 3. Free Trial Account
- 4. Data loading From AWS S3 Bucket
- 5. Python Installation
- 6. dbt Cloud connection with Snowflake and Github
- 7. dbt Core Installation
- 2. dbt(data build tool) Data Warehouse Fundamentals
- 1. Data Warehouse Concepts
- 2. Benefits and Limitation of Data Warehouse
- 3. ETL in Data Warehouse
- 4. ETL vs ELT
- 5. Overview of OLTP
- 3. dbt(data build tool) Models, Sources & Seeds
- 1. Create your First Models
- 2. Creating a Sample Tables for Models
- 3. Use of Ref Function in dbt Model
- 4. Creating a Python Model in dbt
- 5. Creating a Second Python Model in dbt
- 6. Sources in dbt(data build tool)
- 7. Source Freshness in dbt
- 8. Seeds in dbt(data build tool)
- 4. Materialization in dbt(data build tool)
- 1. Ephemeral Model
- 2. Incremental Model Part-01
- 3. Incremental Model Part-02
- 4. Incremental Model Part-03
- 5. delete+Insert Model
- 5. Snapshots in dbt(data build tool)
- 1. Slowly Changing Dimensions Concepts
- 2. Timestamp Strategy SCD TYPE 2
- 3. CHECK STRATEGY SCD TYPE 2
- 6. Jinja Basic Fundamentals
- 1. Jinja Introduction
- 2. Jinja Basics - Control Structures
- 3. Use of Jinja in dbt model Part-01
- 4. Use of Jinja in dbt Part-02
- 7. dbt(Data build tool) Macros and Hooks
- 1. Macro in dbt(data build tool) Part-1
- 2. Macros in dbt(data build tool) Part-2
- 3. dbt Hooks
- 4. dbt documentation
- 8. dbt Testing
- 1. dbt testing
- 2. Singular Testing
- 3. Generic Testing Part-01
- 4. Severity Test in dbt
- 5. dbt Store failure and limit Config
- 6. Custom Generic Test
- 7. dbt_utils
- 8. dbt_expectations
- 9. Audit_helper