SynapseDatabaseObjects.sql

CREATE MASTER KEY ENCRYPTION
	BY PASSWORD = '<Secure String>';

CREATE DATABASE SCOPED CREDENTIAL [SqlCredsMI] 
WITH IDENTITY='Managed Identity';

CREATE EXTERNAL DATA SOURCE DataLakeMI WITH ( 
    LOCATION = 'https://datalakename.dfs.core.windows.net' 
    , CREDENTIAL = SqlCredsMI
);

CREATE EXTERNAL FILE FORMAT DeltaLakeFormat WITH (  FORMAT_TYPE = DELTA );