Using dbt withSynapse Spark

Morning all

I’d like to find out if anyone has managed to get dbt working with against Synapse Spark?

I’ve manged to create a test project which I have configured against Databricks and Synapse Dedicated pool, but I’m wondering if it is even possible to use Synapse Spark as a transformation engine using dbt.

I have created a database with external tables over my parquet\delta sources, but it seems to me that:

(1) the SQL functionality of Synapse’s Spark implementation is too limited
(2) it may not be possible to configure dbt to access Synapse Spark as an end-point.

Any thoughts?

Thanks!

1 Like

I’m also looking to see if it’s possible to use synapse spark with dbt. Is there anybody that can clarify this?