-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Azure Data Engineering Cookbook
By :
PolyBase allows you to query external data in Hadoop, Azure Blob storage, or Azure Data Lake Storage from SQL Server using T-SQL. In this recipe, we'll import data from a CSV file in an Azure Data Lake Storage account into an Azure Synapse SQL pool using PolyBase.
Before you start, log in to Azure from PowerShell. To do this, execute the following command and follow the instructions to log in to Azure:
Connect-AzAccount
You need a Synapse SQL pool to perform the steps in the recipe. If you don't have an existing Synapse SQL pool, you can create one using the steps from the Provisioning and connecting to an Azure Synapse SQL pool using PowerShell recipe.
Follow the given steps to import data into Azure Synapse SQL using PolyBase:
#Create a new Azure Data Lake Storage...