DBT Synapse Serverless
An adapter for dbt to use Azure Synapse Serverless pools.
- Year
- 2024
- 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.
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
Pulsar-MCP
A Model Context Protocol (MCP) server for Apache Pulsar that provides tools to interact with Pulsar clusters through MCP-compatible clients.
Xbooks
Xbooks is an open source self-hosted website that allows users to create and share their own book lists.(name not definitive)