topic Re: Connecting azure synapse through data bricks note books in Data Engineering

Connecting azure synapse through data bricks note books

KVNARK — Tue, 03 Jan 2023 05:13:01 GMT

Hi All,

Happy new year!

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

Re: Connecting azure synapse through data bricks note books

Ajay-Pandey — Tue, 03 Jan 2023 05:19:33 GMT

Hi @KVNARK . you can connect by using JDBC driver

Re: Connecting azure synapse through data bricks note books

KVNARK — Tue, 03 Jan 2023 05:34:12 GMT

Could you elaborate. Any reference would be much appreciated.

Re: Connecting azure synapse through data bricks note books

daniel_sahal — Tue, 03 Jan 2023 06:41:19 GMT

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

Re: Connecting azure synapse through data bricks note books

KVNARK — Tue, 03 Jan 2023 07:58:46 GMT

@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.