Swiss Re selected Azure Synapse Analytics with Power BI for enterprise Analytical & BI solution for faster, more efficient analysis and deeper insights. After implementing Azure Synapse Analytics with Power BI, it loads data almost 40 percent faster than that of loading data in on-premises system allowing to load fresh data more often. โThis not… Continue reading Azure Synapse Power BI: How Swiss Re uses Azure Synapse Analytics with Power BI for faster, deeper and better insight
Tag: azure synapse analytics
Azure Synapse Tutorial: Three In ONE Service
This Azure Synapse Tutorial contains below topic: What is Azure Synapse Analytics? Azure Synapse Analytics brings together data integration, data warehousing and big data analytics under an umbrella dramatically reducing the time to build an analytics solution & accelerating the time to insight. Azure Synapse Analytics Workspace: Video Link for this Azure Synapse Tutorial: More… Continue reading Azure Synapse Tutorial: Three In ONE Service
Azure Data Factory Data Flow: Change Data Capture Architecture & Demo
In this article we will have two real time demo on how Azure Data Factory Data Flow implements Change Data Capture feature. Azure Data Factory and Azure Synapse Mapping Data Flow implements CDC in two ways : Let’s understand below details first: Let’s get connected: Native SQL Change Data Capture feature in Azure Data Factory… Continue reading Azure Data Factory Data Flow: Change Data Capture Architecture & Demo
MERGE command in Azure Synapse Analytics Dedicated SQL pool
In this article we will understand the features of MERGE T-SQL command and have a quick demo on Source table to Sync with target dimension table in Azure Synapse Analytics Dedicated SQL pool. MERGE T-SQL command for Azure Synapse Dedicated SQL pools is now Generally Available MERGE T-SQL feature: It combines INSERTs/UPDATEs/DELETEs into a single… Continue reading MERGE command in Azure Synapse Analytics Dedicated SQL pool
Azure Synapse Link for Azure SQL Database using Change Feed : Demo
In this article we will have a step-by-step demo on how to implement Azure Synapse Link for Azure SQL Database using Change Feed and load data into Azure Synapse Analytics. What is Azure Synapse Link for Azure SQL: โธ๏ธ Azure Synapse Link for SQL Extract data incrementally from transactional databases and Load it directly into… Continue reading Azure Synapse Link for Azure SQL Database using Change Feed : Demo
Azure Managed Identity Authentication for Azure SQL Database by Azure Data Factory
In this article we will have a step by step demo on how usingAzure Managed Identity, Azure Data Factory authenticates Azure SQL Database and Synapse Workspace authenticates Azure Synapse Analytics. Microsoft Recommendation on Passwordless Authentication Managed identities are the recommended authentication option for secure, passwordless connections between Azure resources. Azure Managed Identity Authentication: WHAT it… Continue reading Azure Managed Identity Authentication for Azure SQL Database by Azure Data Factory
Microsoft Azure Unified Data and Analytics Architecture
๐๐ข๐๐ซ๐จ๐ฌ๐จ๐๐ญ ๐๐ณ๐ฎ๐ซ๐ ๐ง๐๐ญ๐ข๐ฏ๐ ๐ฎ๐ง๐ข๐๐ข๐๐ ๐๐๐ญ๐ ๐๐ง๐ ๐๐ง๐๐ฅ๐ฒ๐ญ๐ข๐๐ฌ ๐ฉ๐ฅ๐๐ญ๐๐จ๐ซ๐ฆ: ๐๐ซ๐๐ก๐ข๐ญ๐๐๐ญ๐ฎ๐ซ๐ Let’s have a quick view on the sample use cases and architectural components of this Unified Data and Analytics platform using Azure native data services. This architecture consistent of all components From data source to staging blob storage via ingestion and Subsequently clean and transformation, Stores… Continue reading Microsoft Azure Unified Data and Analytics Architecture
Cast Transformation DEMO in Mapping Data flow of Azure Data Factory
Recently Cast transformation is introduced to Mapping Data Flow in Azure Data Factory and Azure Synapse Analytics. In this article, we will perform a quick demo on how to use this cast transformation in data flow. We will also explore every option available in Cast transformation Settings. How Cast Transformation helps Data Engineer? It allows… Continue reading Cast Transformation DEMO in Mapping Data flow of Azure Data Factory
Azure Synapse Analytics Introduced Intelligent Cache for Apache Spark to improve performance of repeat queries
Microsoft recently introduced Intelligent Cache for Apache Spark engine in Azure Synapse Analytics as part of Azure Synapse Caching. This Intelligent Cache of Apache spark pool in synapse reduces the total cost of ownership (TCO) by improving performance for reading the remote file types in data lake: Parquet files: up to 65% on subsequent reads… Continue reading Azure Synapse Analytics Introduced Intelligent Cache for Apache Spark to improve performance of repeat queries
How to create and use Flowlet transformation in Azure Data Factory and Azure Synapse pipeline
FLOWLET is a re-usable components in mapping data flow-> consisting of series of transformation steps to be used in several dataflow as transformation i.e. flowlet is to be reused by many dataflow so that transformation steps are not repeated in each data flow as flowlet contains the series of transformation steps. To understand term FLOWLET… Continue reading How to create and use Flowlet transformation in Azure Data Factory and Azure Synapse pipeline