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