dbt

Interesting tools to link to dbt

• dbt-metabase for Metadata service
• fal-ai/fal: do more with dbt. fal helps you run Python alongside dbt, so you can send Slack alerts, detect anomalies and build machine learning models. (github.com)
• What is re_data? | re_data docs (getre.io)

Unit testing with macros

• How to set up a unit testing framework for your dbt projects | by Betsy Varghese | Servian
• dbt-unit-test · PyPI
• Writing Unit Tests for dbt - with TDD | Equal Experts
• How to Build a Production Grade Workflow with SQL Modelling — Data Science & Engineering (shopify.engineering)

Best practices

• How to Configure Your dbt Repository (One or Many)? | dbt Developer Blog
  • If you choose the route of multiple repos… orchestration becomes difficult (Workflow orchestrators):
    • Better mechanisms for cross-project lineage · Discussion #5244 · dbt-labs/dbt-core
    • Orchestrating in cross-project: The evolution of data orchestration: Part 1 - the past and present
• Mythical article with project structure: https://docs.getdbt.com/guides/best-practices/how-we-structure/1-guide-overview
• Always type cast? https://discourse.getdbt.com/t/define-column-data-type-in-dbt/826/4