Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
supri03
Helper I
Helper I

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 !

1 ACCEPTED SOLUTION
v-nikhilan-msft
Community Support
Community Support

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.

View solution in original post

1 REPLY 1
v-nikhilan-msft
Community Support
Community Support

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.