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

Question

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?

Answer 1

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