dbt Analytics Engineer [draft]
Creating and Maintaining dbt documentation Debugging data modelling errors Developing dbt models Materialisation Implementing and Maintaining External Dependencies Implementing dbt tests Indirect Selection Leveraging the dbt state Managing data pipelines Understanding dbt models governance restrict-access configuration Core Concepts Common dbt commands Hooks Materialisation Semantic Layer Snapshot How to create snapshot Valid configurations in dbt_project.yml dbt Tests Why do we need test? What makes a good test? Test on One Database Object Troubleshooting Table missing primary key constraint during execution Optimise SQL models with {{ref()}} function Best Practices Structure a dbt project Reference Creating and Maintaining dbt documentation Debugging data modelling errors Developing dbt models Materialisation view incremental table ephemeral If the materialized option is not specified, the default dbt materialisation is view....