Azure Data Factory - How to inspect schema of Avro files?

ADF is unable to infer schema of Avro files. Here is the solution.

Posted by Bernard Lim on January 11, 2020

Problem

Avro file format is the only format when capturing events from Event Hub.
However Avro files cannot be processed directly (To inspect schema) on Data Factory.

Solution

Use a Databricks activity which will read Avro files into DataFrames, and eventually convert them into a CSV/JSON file. From there the schema can be inferred.