In real time, the column names from source might not be uniform, some columns will have a space in it, some other columns will not. For exampl...
Script activity in Azure Data Factory\ Synapse analytics is very helpful to run queries against data sources mentioned here in this document.&...
Continuing the series of this blog posts I would like to go more advanced on troubleshooting connectivity issues. I would like to thank also&n...
Introduction Azure Synapse Analytics Serverless SQL is a query service mostly used over the data in your data lake, for data discovery,...
Overview The crucial first step in any ETL (extract, transform, load) process or data engineering program is ingestion, w...
Over the past year, customers have informed the team there were a set of key columns missing in the standalone Dedicated SQL pools (formerly S...
Have you ever deployed a release to production only to find out a bug has escaped your testing process and now users are being severely impact...
About this blog series Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the ...
Author(s): Pradeep Srikakolapu is a Program Manager in Azure Synapse Customer Success Engineering (CSE) team. Automating de...
As organizations continue to collect and store large volumes of data in their data lakes, managing this data effectively becomes increasingly ...
