microsoft/dbt-synapse

Azure Synapse serverless pool

AndresNamm opened this issue · 1 comments

Do you have a plan to implement a feature that allows to access Azure Synapse with the serverless pool as well? Currently, it seems this is not possible because the Azure Synapse serverless pool is based on external tables.

great question! actually dbt-labs/dbt-external-tables supports Azure Synapse. So you can make external tables using that package (example), then, as long as your whole make all your dbt models views, it should work!

Our team uses this pattern extensively.

I'm going to close this issue, but please reply back if you have any questions!