In-Database Python Analysis for SQL Developers
In-Database Python Analysis for SQL Developers
Step 2: Import data into SQL Server using PowerShell
In this step, you will download the sample dataset and script shared on Github by the PowerShell script to a local directory of your choice.
Use ** Run as administrator ** if you need administrator privileges to create a download directory or write files to the specified download destination.
Run the following PowerShell command to change the value of the parameter DestDir to your local directory. Here, ** C: \ tempPythonSQL ** is specified as the download destination directory.
$source = 'https://raw.githubusercontent.com/Azure/Azure-MachineLearning-DataScience/master/Misc/PythonSQL/Download_Scripts_SQL_Walkthrough.ps1'
$ps1_dest = "$pwd\Download_Scripts_SQL_Walkthrough.ps1"
$wc = New-Object System.Net.WebClient
$wc.DownloadFile($source, $ps1_dest)
.\Download_Scripts_SQL_Walkthrough.ps1 -DestDir 'C:\tempPythonSQL'
If the folder specified by DestDir does not exist, it will be created by the PowerShell script.
Depending on your internet connection, it may take some time to download. Once all the files have been downloaded, run the following command at the PowerShell command prompt to see the downloaded files.
ls
Step 2: Import data into SQL Server using PowerShell
In-Database Python Analysis for SQL Developers
In-Database Python Analysis for SQL Developers
Step 1: Download the Sample Data
Machine Learning Services with Python
Recommended Posts