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!