title: Synapse Query from Delta Lake Databricks with SSMS
body: <p>I would to know if there are any way to <strong>query</strong> table <strong>Delta</strong> format from blob container that was created using <strong>Databricks</strong> with <strong>SSMS</strong> or <strong>Azure Data Studio</strong> which is SSMS are connected to Azure Synapse, I've tried to query with this query</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT TOP(10) * FROM OPENROWSET(BULK 'https://blob_container_storage.blob.core.windows.net/delta-lake/test/', FORMAT = 'DELTA') as rows
  </code></pre>
  <p>From above query I got an error like this</p>
  <pre><code>Msg 103010, Level 16, State 1, Line 188
  Parse error at line: 1, column: 22: Incorrect syntax near 'OPENROWSET'.
  </code></pre>
  <p>So, I want to ask, Is it possible to query delta lake from synapse using SSMS or Azure Data Studio ?</p>