Synapse workspace: Load data using Polybase and Managed Identity

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

Synapse TSQL: variable assignment in SELECT statement cannot be included

When working with synapse as a TSQL developer, it does feel like you've gone in a time warp back to SQL 7.0 in terms of whats supported and whats not. Luckily most of the TSQL patterns not supported have some form of workaround. This one I'm looking at is the naughty practice of doing variable … Continue reading Synapse TSQL: variable assignment in SELECT statement cannot be included