json files shortcut in ADLS Gen2

[atul06]

Hi Team ,

I have json file in ADLS Gen 2 Storage and I'm not able to create shortcut for json file. Let me know how to create shortcut for json files in Lakehouse ?

[Anonymous]

Hi @atul06 , Thanks for using Fabric Community.

As I understand you trying to create a shortcut for json file.

In order to create a shorcut for json please follow below steps:

1. Go to MS Fabric Lakehouse.




 2. Please fill the necessary details:

Note: You can find your endpoint from ADLS Gen 2 in azure portal


After sucessfully given the details you will able to find the shortcut in MS Fabric Lakehouse.





Hope this is helpful. Please let me know incase of any queries.

[atul06]

@Anonymous  Thanks for providing solution. I have created json short cute, however when i m trying to load to tables , i m not getting json file type option . How create table from JSON file ?

[Anonymous · Accepted solution]

Hi @atul06 ,

Thats Great! you were able to load your json from ADLS Gen2.
In order to load this json to table in lakehouse, you can follow below steps.
Note: We have several approaches, I am showing with help of Notebooks and Spark.

Initially create a New Notebook in Fabric and link the existing Lakehouse where the json file is located.  After creation of Notebook,

On following above you will be able to load the json data in dataframe successfully.


On following above steps you will be able to save and create tables from dataframe and you can find them on right side after doing a refresh.


Finally, if you go to your lakehouse and do a refresh (if required) you will able to find you json data in form of table.

You can refer to this document inorder to learn how to use spark in Fabric: Link 

Hope this is helpful. Please let me know incase of any further queries.

Happy Learning!

[atul06]

@Anonymous  Thanks its working for me through spark . Can we directly load json files directly from shortcut method?

[Anonymous]

Hi @atul06 ,

Currently we have few limitations with shortcuts and we don't have this option to load directly the json files.

Appreciate if you could share the feedback on our feedback channel . Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Hope this helps. Please let me know if you have any further queries.

[atul06]

Thank for information and solution

[Anonymous]

Hi @atul06 ,

Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[ajarora]

Consider using pipelines copy activity for data ingestion into lakehouse tables, it supports several file types and connectors including json files in adls gen2 storage.

pipeline tutorial can be found online, like this: https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-end-to-end-pipeline

[Anonymous]

Hi @atul06 ,

Attaching Link for Shorcuts inorder to understand them better:
ADLS Shorcut Link 

Hope this is helpful. Please let me know incase of any queries.