Azure Blob to Lakehouse Pipeline

[supri03]

Hey there, 

I have a pipeline that connects blob to lakehouse. The files I have in Blob are JSON, and I have many files. My goal is to append these files into the lakehouse as a single table. I initially had these JSON files as csv and all of them were appended into a single table in delta format in Tables folder of the lakehouse. However, when I try the same with JSON, The pipeline is not allowing me to dump it in the Tables folder. 

Additionally, I have observed that in the Lakehouse, that JSON files do not have load data to Tables option:

However for CSV, I can load it into the Tables folder of delta format. Are certain types of files not supported ?

Please help me out, thanks for your help !

[HimanshuS-msft · Accepted solution]

Hello @supri03 
Thanks for using the Fabric community.

I did tried out the scenario which you mentioned and it worked fine for me . In my case i just copied two json file to a table . 

In my case had the sttorage account and a cantainer and a path where you I had kept that files . You will have to select the Wilcard path option ( i see that you are selecting the File path ) 

Let me know how it goes . 

Thanks
HImanshu

[v-cboorla-msft]

Hi @supri03 

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

Thanks