What File Types are supported in KQL DB ?

[supri03]

Hey community, 

I have a folder like this:
 year/month/Jan/

In Jan, I have sub folders like day 1, day 2, ....

In these days folders, I have many files for instance day 1 has .json, .csv, and day 2 has .xml, .xlxs

All of them have the same schema. So I have used a KQL to get them via pipeline and all of these different types of files were appended into a single table. I'd like to know what kinds of file formats it won't append, or not supported in a KQL DB.

Thanks !

[v-nikhilan-msft · Accepted solution]

Hi @supri03 
Thanks for using Fabric Community.

Data Explorer supports different types of mappings, both row-oriented (CSV, JSON, AVRO and W3CLOGFILE), and column-oriented (Parquet and ORC).

For more information please refer to this link: Link1

Hope this helps. Please let us know if you have any further questions.