Forum Discussion
Avi21
May 15, 2020Copper Contributor
JSON File Data To Azure Datawarehouse thru Azure data factory
Hello, Is there any way JSON file data can be copied to Azure Data-warehouse thru Azure data factory without converting into CSV? Thanks in advance. Cheers...
DanielPerlovsky
May 18, 2020Iron Contributor
JSON files can be copied into a DW with either the Copy activity or Mapping Data Flow. If you are doing a straight copy, I recommend copy. If you are doing any sort of transformation or converting hierarchies to flat schemas, use mapping data flow