[In-Database Python Analysis Tutorial with SQL Server 2017] Step 1: Download sample data
From the beginning of the tutorial
In-Database Python Analysis for SQL Developers
Previous step
In-Database Python Analysis for SQL Developers
Next step
Step 2: Import data into SQL Server using PowerShell
Step 1: Download sample data
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.
Download data and scripts
- Open the Windows PowerShell command console.
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
Link
Next step
Step 2: Import data into SQL Server using PowerShell
Previous step
In-Database Python Analysis for SQL Developers
From the beginning of the tutorial
In-Database Python Analysis for SQL Developers
Source
Step 1: Download the Sample Data
Related item
Machine Learning Services with Python
Recommended Posts