Script used: CREATE MASTER KEY ENCRYPTION BY PASSWORD = ; CREATE DATABASE SCOPED CREDENTIAL SQL_Credential WITH IDENTITY = 'abcde', SECRET = ; ; CREATE EXTERNAL DATA SOURCE MyElasticDBQueryDataSrc WITH (TYPE = RDBMS, LOCATION = 'remoteserver.windows.net', DATABASE_NAME = 'DB_name', CREDENTIAL = SQL_Credential ) ; CREATE EXTERNAL TABLE [STG].[Account]( [Id] int NOT NULL, [Network_External_id__c] nvarchar(256) NULL, ) WITH ( DATA_SOURCE = testExtDtaSource );