Data Lake Storage to Synapse Analytics using Managed Service Identity (MSI) – COPY INTO and PolyBase

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

Configure Managed Identity in Synapse Analytics Workspace using PowerShell

Prerequisites: Synapase Analytics workspace is created along with Data Lake Storage gen2 Step 1: Create new linked Service for a workspace Log in to Synapase analytics workspace from Azure portal and Create new Linked services and select Azure Synapse Analytics (SQL DW) Set up Authentication method for linked service as Managed Identity. Once a linked … Continue reading Configure Managed Identity in Synapse Analytics Workspace using PowerShell