dbt

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....

0 - General dbt Fundamentals dbt Developer Hub 1 - Who is an Analytics Engineer? Traditional Data Teams Data Engineers Data Engineers are in charge of building the infrastructure that data is hosted on, usually databases. DE also manage the ETL process to ensure data is where it needs to be, and in tables for Data Analysts to query. Skill set for Data Engineers include SQL, Python, java, other functional programming languages....