Connecting azure synapse through data bricks note books

[KVNARK]

Hi All,

Happy new year!

how can we connect to azure synapse serverless sql pool through databricks notebooks and execute DDLs

[Ajay-Pandey]

Hi @KVNARK .​ you can connect by using JDBC driver

[KVNARK]

Could you elaborate. Any reference would be much appreciated.

[daniel_sahal · Accepted solution]

@KVNARK .​ https://joeho.xyz/blog-posts/how-to-connect-to-azure-synapse-in-azure-databricks/

[KVNARK]

@Daniel Sahal​ Thanks a lot for sharing the details. For more details could you help on the below too: how to execute Create view statements through SPN (Service Principal Name) in serverless SQL pool.