Synapse Query from Delta Lake Databricks with SSMS

Question

I would to know if there are any way to query table Delta format from blob container that was created using Databricks with SSMS or Azure Data Studio which is SSMS are connected to Azure Synapse, I've tried to query with this query

SELECT TOP(10) * FROM OPENROWSET(BULK 'https://blob_container_storage.blob.core.windows.net/delta-lake/test/', FORMAT = 'DELTA') as rows

From above query I got an error like this

Msg 103010, Level 16, State 1, Line 188
Parse error at line: 1, column: 22: Incorrect syntax near 'OPENROWSET'.

So, I want to ask, Is it possible to query delta lake from synapse using SSMS or Azure Data Studio ?

Answer 1

Yes, that is possible. Check out this article for details: Query Delta Lake files (preview) using serverless SQL pool in Azure Synapse Analytics

Please make sure that you are connecting to built-in serverless pool as this isn't supported in dedicated pools yet.