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

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

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
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-06-05T09:55:53.867+00:00
    Vaibhav Chaudhari 37,746 Reputation points

    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

    No comments