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

Wayne 1 Reputation point
2020-06-05T04:32:52.85+00:00

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
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,561 Reputation points
    2020-06-05T09:55:53.867+00:00

    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

    1 person found this answer helpful.
    0 comments