01 - What is dbt and Why Analytics Engineering is Revolutionizing the Data Stack
dbt 10 min Cos'è dbt e Perché l'Analytics Engineering Sta Rivoluzionando il Data Stack dbt porta il software engineering nel SQL: versioning con Git,...
dbt
Series “dbt”: it starts with “02 - dbt Core Setup: Project Structure, Connection Profiles and First SQL Transformation”. dbt 14 min dbt Core Setup: Project Structure, Connection Profiles and First SQL Transformation From command line to first transformation:...
This series collects 10 articles (approximately 146 minutes of total reading time), designed for a level Beginner. The main topics covered are dbt core, dbt, analytics engineering, ELT.
10Articles146 minTotal reading timeBeginnerLevel
dbt coredbtanalytics engineeringELTdata transformationdbt init
Series Articles
- 1
- 2
02 - dbt Core Setup: Project Structure, Connection Profiles and First SQL Transformation
dbt 14 min dbt Core Setup: Project Structure, Connection Profiles and First SQL Transformation From command line to first transformation:...
- 3
03 - Jinja and Macros in dbt: Dynamic SQL, Templating and Custom Macros
dbt 15 min Jinja e Macro in dbt: SQL Dinamico, Templating e Macro Personalizzate Jinja trasforma dbt da strumento SQL a framework di trasformazione...
- 4
04 - dbt Materializations: Table, View, Incremental Models and Snapshots for Change Data Capture
dbt 17 min Materializzazioni dbt: Table, View, Modelli Incrementali e Snapshot per Change Data Capture Scegliere la materializzazione giusta cambia tutto:...
- 5
05 - Testing in dbt: Generic Built-in Tests, Custom SQL Tests and dbt-expectations
dbt 14 min Testing in dbt: Test Generici Built-in, Test SQL Personalizzati e dbt-expectations dbt test garantisce la qualità dei dati: 4 test generici...
- 6
06 - Automatic Documentation in dbt: YAML Descriptions, Data Lineage and dbt Catalog
dbt 12 min Documentazione Automatica in dbt: Descrizioni YAML, Data Lineage e dbt Catalog dbt genera automaticamente documentazione e lineage graph dal...
- 7
07 - dbt Core vs dbt Cloud: Differences, Use Cases and How to Choose the Right Solution
dbt 11 min dbt Core vs dbt Cloud: Differences, Use Cases and How to Choose the Right Solution dbt Core is open-source and free but requires infrastructure...
- 8
08 - CI/CD for dbt: GitHub Actions, Slim CI with State and Automatic Testing on Pull Request
dbt 16 min CI/CD for dbt: GitHub Actions, Slim CI with State and Automatic Testing on Pull Request How to automate dbt testing and deployment with GitHub...
- 9
09 - Advanced Incremental Models in dbt: Merge Strategies, Microbatch and Change Data Capture
dbt 18 min Advanced Incremental Models in dbt: Merge Strategies, Microbatch and Change Data Capture Beyond basic incremental: microbatch strategy for...
- 10
10 - dbt in Production: Data Governance, Semantic Layer and Orchestration with Airflow
dbt 19 min dbt in Produzione: Data Governance, Semantic Layer e Orchestrazione con Airflow Architettura dbt enterprise: accesso granulare a modelli con...