Anybody ever use Azure Synapse? I was talking with someone on the dataengineering subreddit and I wasn’t familiar with it. I see there’s a community dbt adapter for it but I couldn’t find a target.

the Apache Superset community recently added better support for it! But I haven’t had a chance to use it yet 😞

Their website was a little confusing to me at first b/c I was trying to understand if it was comparable to Redshift or Athena. I haven’t seen many folks use it in the wild tbh

My understanding is the ODBC driver for MSSQL works with Synapse so theoretically the target mssql I'm working with should work, if that's any help (it only works with FULL table syncs right now)

Probably worth pointing out there are sort of two Synapses. What used to be "Azure Data Warehouse", think Redshift, which they renamed Synapse a while ago. Then there is the newer "Azure Synapse Analytics", which has the above as "Dedicated SQL Pools", but also Spark Pools, Serverless SQL Pools (think Athena), Data Factory equivalents and probably more by now.

They’re taking a page from the Google Chat app marketing book I see 😖

I was looking about Azure Synapse. Has anyone has a successful pipeline to it? I'm triying your target-mssql @visch but I think that I miss some drivers because I cannot connect. That's I want to know if someone has a successful connection to Azure Synapse.

Can you make a separate thread and link to this as this is so old? Id hate to miss someone new that might know about this just because this is an old thread