Why to use MSI? Easy to authenticate any Azure Active Directory supported serviceProvides limited visibility of the credentialsMore secured than SQL authentication and less susceptible to hacking Configuration steps Create a storage account and enable Hierarchical namespace for Data Lake Storage Gen2.Within storage account, create a container for file system .Navigate to Access Control to … Continue reading Data Lake Storage to Synapse Analytics using Managed Service Identity (MSI) – COPY INTO and PolyBase
Tag: DW
Configuration Steps Create a Azure Data Lake Storage Gen 2 storage account, make sure to enable Hierarchical namespace. Read Microsoft KB here.Create a Synpase workspace and select newly created data lake storage as Account name and blob container as File System name. Assign Storage Blob Data Contributor permissions to Synpase Workspace in the Storage account. … Continue reading Synapse workspace: Load data using Polybase and Managed Identity