Data wangling

Copper Contributor

I am working on Azure Cloud platform and have a relatively small sensitive data set (1 Go) I want to extract from an Sql Server to analyze.

I have created an Azure ML platform to analyze the data from notebooks.

 

My question is, what would be the simplest way to extract the data from Sql Server to analyze from a notebook?

 

I have tried to use Sql Server Mgt Studio to save directly the result of a query to a text file but the only option is to save it on my local computer which I cannot!!! There is no option to save it in the Azure ML storage!!!

 

Many thanks in advance for your help.

1 Reply

@jmd972 

You can query your Azure SQL database directly from your notebook. There is a sample for that, you can find it here: https://notebooks.azure.com/Microsoft/projects/samples/html/Getting%20to%20your%20Data%20in%20Azure%...