Azure Synapse SQL Pool – Implement Polybase
Evaluate Your Project Knowledge
What is the purpose of creating external data source?
Creating a external table is mandatory to read the data stored in Azure Data Lake account.
Using polybase, data from the Customer.txt file will be loaded in the external table
Is the following sequence to configure polybase correct or not?
Create master Key;
create database scoped credential
create external data source
create external file format
create external table
The external table can be used to join(inner/left/right) with other normal tables in a SQL statement.