dbt

1. What is dbt

   dbt's role in transforming data in the warehouse with SQL and version control.

2. Projects and Configuration

   dbt_project.yml, project structure and configs.

3. SQL Models

   Building models with select statements and ref().

4. Materializations

   View, table, incremental and ephemeral materializations.

5. Incremental Models

   Incremental strategies, unique keys and late-arriving data.

6. Sources

   Declaring raw sources and freshness checks.

7. Data Tests

   Generic and singular tests for data quality.

8. Unit Tests

   Testing model logic with mocked inputs.

9. Jinja and Macros

   Jinja templating, macros and reusable SQL.

10. Snapshots and Seeds

    Slowly changing dimensions via snapshots, and CSV seeds.

11. Packages

    Reusing code via dbt packages.

12. Documentation and Lineage

    Docs generation, descriptions and lineage graph.

13. Deployment and Jobs

    Running dbt in production with jobs and CI.

14. Contracts, Versions and Governance

    Model contracts, versions, access and mesh.

Each section links to the official page. Titles and summaries by Extra Credit; the docs belong to their authors.