question

waynethompson avatar image
0 Votes"
waynethompson asked azure-cxp-api edited

Azure Data Studio - How do you connect to Sql Azure with Python and R notebooks.

Azure data studio is pretty amazing.The sql notebooks look like something we will start to use all the time.As I saw Hanselman say in a video, we all have folders full of sql scripts with comments in them for processes to follow.

What I am struggling with, is there an easy way to connect to Azure Sql with R and Python notebook.

I usually use exported files for this but it would be awesome to connect straight to the database.We could put the connection string in the notebook but we don't really want it in source control.

If it could pickup the connections from the app that would be great or alternatively use managed identities to connect.

What would be really cool is if it simplified the connect of a notebook to both Azure Sql and CosmosDB so that I could just focus on the queries and not worry about the connection string.

Is there a better place to ask this question?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

VaibhavChaudhari avatar image
1 Vote"
VaibhavChaudhari answered

There is a github page where Azure data studio issues, improvements can be posted

Link - https://github.com/microsoft/azuredatastudio/issues




If the response helped, do "Accept Answer" and upvote it - Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.