Azure Data Factory mapping data flows adds SQL scripts to sink transformation

Azure Data Factory has added the ability to execute custom SQL scripts from your SQL sink transformation in mapping data flows. Now you can easily perform options such as disabling indexes, allows identity inserts, and other DDL/DML operations from data flows.

28/08/2019AnalyticsData Factory

Share:

You may be interested in

‘Key influencers’ AI visual is now available in Power BI Embedded analytics to help users identify what factors influence a KPI
Analytics, Power BI Embedded
The Key influencers visual surfaces what factors influence a KPI. For example, users may want to analyze what factors impact user satisfaction of a product. Factors that can impact this…
07/06/2019
Accelerate analytics and AI workloads with Photon powered Delta Engine on Azure Databricks
Analytics, Databricks
Photon powered Delta Engine is a 100% Apache Spark-compatible vectorized query engine designed to take advantage of modern CPU architecture for extremely fast parallel processing of data.
22/09/2020
Azure Data Lake tools for Visual Studio: December update
Analytics, Data Lake Analytics
This update to the Data Lake tools for Visual Studio adds local run and editing improvements.
08/01/2016
Azure Analysis Services—Improved query replica synchronization now available
Analytics, Analysis Services
Improved query replica synchronization in Azure Analysis Services is now generally available. Analysis Services features improved query-replica synchronization in scale-out environments with client queries distributed across one or more query…
16/04/2020
Azure Data Lake Store and Azure Data Lake Analytics integration with Azure Data Factory
Analytics, Data Lake Analytics
You can use Azure Data Factory to move data to and from Data Lake Store, and you can run queries with Data Lake Analytics.
18/11/2015
Azure HDInsight TLS 1.2 Enforcement
Analytics, HDInsight
Starting on June 30, 2020, Azure HDInsight will enforce TLS 1.2 or later versions for all HTTPS connections. We recommend that you ensure that all your clients are ready to…
13/01/2020
Azure Event Hubs for Apache Kafka is now available
Analytics, Event Hubs
With Azure Event Hubs for Apache Kafka, we’re bringing together two powerful distributed streaming platforms so you can access the breadth of Kafka ecosystem applications without having to manage servers…
14/11/2018
Public preview: Capture Event Hubs data with Stream Analytics no-code editor in Delta Lake format
Analytics, Stream Analytics
Stream Analytics no-code editor now supports capturing Event Hubs data into ADLS gen2 with Delta Lake format.
09/01/2023
Generally available: Azure Event Hubs Dedicated self-serve scalable clusters for mission critical Kafka, AMQP and HTTPs workloads
Analytics, Event Hubs
Run you mission critical Kafka, AMQP and HTTPS event streaming workloads with consitenct low latency.
01/05/2023
COPY command now generally available in Azure Synapse Analytics
Analytics, Synapse Analytics
The COPY command can now automatically parse your files to calculate file splits and can evenly distribute data chunks across the Synapse SQL compute nodes for parallel ingestion.
23/09/2020
General availability: Event Hubs Premium
Analytics, Synapse Analytics
Event Hubs Premium comes with reserved compute, memory, and storage resources, which increases the performance and minimizes cross-tenant interference in a managed multi-tenant PaaS environment.
02/11/2021
General availability: Event Hubs for Node.js
Analytics, Event Hubs
Version 1.0 of the Azure Event Hubs package for Node.js is now generally available.
20/09/2018