Share via

How to insert data in Azure Synapse Analytics through Azure Data factory without PolyBase

m d 26 Reputation points
2020-07-30T03:57:37.353+00:00

I have tried using Move and Transfar activity in data factory but I'm getting 2 error at publishing:
'
Data flow activity 'dataflow1' requires a stagingLinkedService
Data flow activity 'dataflow1' requires a stagingStoragePath
'

I don't want to use PolyBase. What should I do.
* Azure SQL Database will success if not Azure Synapse Analitics

14407-errorflow.png
14400-errorflow2.png

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.
4,504 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,805 questions
0 comments
Accepted answer
  1. Mark Kromer MSFT 1,146 Reputation points
    2020-07-30T05:13:11.22+00:00

    If do not wish to utilize Polybase for this data loading, then uncheck "Enable Staging" in the Sink in your data flow. Just understand that your data will load much slower.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest