How to load avro files from blob storage to azure data factory MOVING DATA FLOW?

0
votes

How to load avro files from blob storage to azure data factory MOVING DATA FLOW? I'm trying to load but unable to import schema and preview. My avro files in blob are result of event hub capture function. I have to move data from azure blob to azure sql db using azure data factory's moving data flow.

1
avroazure-data-factoryazure-data-factory-2azure-blob-storageazure-eventhub-capture

1 Answers

1
votes

Data Factory support Avro files.

In Data Flow, create a new Source from Azure Blob Storage: enter image description here

Choose the Avro format for your files: enter image description here

Choose the file path:

enter image description here

Then you can add the sink to Azure SQL dataset:

enter image description here

Here is another tool may be helpful for you: Load AVRO Files Data to Azure SQL Database in Real Time

Hope this helps.