Azure SQL DW External Table - Simple Example

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'some strong password ' ;

-- Create a database scoped credential with Azure storage account key as the secret.
CREATE DATABASE SCOPED CREDENTIAL AzureStorageCredential
WITH
  IDENTITY = '$$$ azstoreaccount $$$ ' ,
  SECRET = ' $$$ azure storage secret key $$$ ;

-- Create an external data source with CREDENTIAL option.
CREATE EXTERNAL DATA SOURCE MyAzureStorage
WITH
  ( LOCATION = 'wasbs://azcontainer@azstoreaccount.blob.core.windows.net/' ,
    CREDENTIAL = AzureStorageCredential ,
    TYPE = HADOOP
  ) ;
 
 
 CREATE EXTERNAL FILE FORMAT TextFileFormat
WITH
(
    FORMAT_TYPE = DELIMITEDTEXT,
    FORMAT_OPTIONS
    (
        FIELD_TERMINATOR = '|',
        USE_TYPE_DEFAULT = FALSE
    )
);


CREATE EXTERNAL TABLE employee_d(
id int,
name varchar(120)
)
WITH (LOCATION='/',
    DATA_SOURCE = MyAzureStorage,  
    FILE_FORMAT = TextFileFormat,
    REJECT_TYPE = VALUE,
    REJECT_VALUE = 0
);  


Select * from employee_d;