DBT Synapse Serverless
An adapter for dbt to use Azure Synapse Serverless pools.
- Year
- 2025
- Role
- Author and maintainer
- Type
- Open source
Overview
A dbt adapter targeting Azure Synapse Serverless SQL pools. Serverless pools behave differently from a dedicated warehouse — no persisted tables, external data read straight from the data lake — so the standard Synapse adapter's materialisations do not apply.
The adapter maps dbt's model materialisations onto what serverless actually supports (views and external tables over lake storage) and handles the connection, credentials and catalogue queries dbt expects.
Forked from https://github.com/r-vlingen/dbt-synapse-serverless
Stack
dbt
Transformation framework being extended
Azure Synapse Serverless
Target SQL engine over data lake storage
Python
Adapter implementation
T-SQL
Materialisation macros and catalogue queries
Highlights
- Materialisations adapted to serverless constraints (views / external tables)
- Reads directly from data lake storage, no dedicated pool required
- Open source under Germain-D/dbt-synapse-serverless
Other projects
Veille IA
A Rust service that builds a daily French digest of AI research — provider blogs and feeds, summarized through an LLM and published to Cloudflare R2.
highlight2anki
A Chrome extension that sends any word you read on the web to Anki in one right click, with its translation, its French definition and the sentence it came from.