Use a PowerExchange for Microsoft Azure Data Lake Store connection to read data from ADLS data objects.

The following table shows the complex files that a mapping can process within ADLS storage in the Databricks environment:

File Type	Format
Avro	Flat Hierarchical
JSON	Flat Hierarchical
Parquet	Flat Hierarchical
The read operation for hierarchical files must be enabled to project columns as complex data type.