dZm7CGDU

1exec sp_configure @configname = 'polybase enabled', @configvalue = 1;
2	
3SELECT SERVERPROPERTY ('IsPolyBaseInstalled') AS IsPolyBaseInstalled;
4	
5CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';  
6
7CREATE DATABASE SCOPED CREDENTIAL AzureStorage
8WITH IDENTITY = 'user', Secret = 'SecretKey';
9
10CREATE EXTERNAL DATA SOURCE AzureStorage with (  
11  TYPE = BLOB_STORAGE,
12  LOCATION ='wasbs://blob@container.blob.core.windows.net',  
13  CREDENTIAL = AzureStorage  
14);
15	
16CREATE EXTERNAL FILE FORMAT taxifileformat  
17WITH (  
18    FORMAT_TYPE = DELIMITEDTEXT,   
19    FORMAT_OPTIONS (FIELD_TERMINATOR =',')  
20);