Forum Discussion

supri03's avatar
supri03
Icon for Advocate I rankAdvocate I
2 years ago
Solved

What File Types are supported in KQL DB ?

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 !

data engineering
Eventhouse and KQL
Real-time Analytics
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.