Azure Databricks Delta Table vs Azure Synapse Lake Database Table-CodePudding

I am struggling to understand something here and im sure the answer is simple....when I run this command in a Databrick note book:

(df.write
 .format("delta")
 .option("path", "/file/path/location")
 .saveAsTable("MyTable"))

It creates a delta table. Okay Great! but if I run the same command in azure synapse spark notebook....it creates a table... Does Synapse now support delta tables? According to this stack overflow post it does not.

So my question is...whats the difference?

Thanks in advance!

CodePudding user response：

Azure Synapse Analytics has a number of engines such as Spark and SQL. Synapse Spark pools support Delta Lake. Synapse Serverless SQL pools recently supports reading from Delta Lake. Synapse Dedicated SQL Pools do not support Delta Lake at this moment.

That other StackOverflow answer is out of date. It was only discussing Synapse Serverless SQL Pools. I added a comment asking him to update it.