Data Load from Databricks Delta table to Azure Synapse Table using ADF

2023-11-21T11:53:28.8333333+00:00

I have a requirement to load data from Databricks delta table to Azure Synapse. Can I use normal copy activity with source as Delta Connector and Sink as Azure synapse using normal pipelines than dataflow? Does this work with normal pipelines or only with dataflow?

Looking for good performance to load data from databricks delta table to synapse using ADF

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,309 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,406 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,444 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vinodh247 32,366 Reputation points MVP
    2023-11-21T14:48:41.5933333+00:00

    Hi Rajagopalan Nair, Rajesh (Cognizant):

    Thanks for reaching out to Microsoft Q&A.

    Yes, you can. Pls find the link below with step-by-step instructions on how to perform this written by pradeep.

    https://stackoverflow.com/a/68131038

    Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.