custom dbt adapter for Azure Synapse serverless pools. This adapter largely inherits from dbt-synapse, which itself inherits from dbt-sqlserver. For more info, see those repos.
dbt-synapse-serverless
and dbt-synapse
In serverless pools, you can't:
schema.relation
)
this adapter is an experiment, here be dragons! I really don't even recommend you use dbt with serverless
This is not published to PyPI. for now, install from Github with:
pip install git+https://github.com/dbt-msft/dbt-synapse-serverless.git
Please see the Authentication section of dbt-sqlserver's README.md.
The only difference is to provide the adapter type as synapseserverless
so for example:
jaffle_shop:
target: serverless
outputs:
serverless:
type: synapseserverless
driver: "ODBC Driver 17 for SQL Server"
schema: dbo
host: <serverlessendpoint>
database: <serverlessdb>
authentication: CLI