How to Connect to a json/csv file from local machine

This article shows how to connect to a json file placed on your local desktop. The same approach can be followed for csv files

1. Click NDP File System.

image-20240830-002828

2. Double-click "file-store"

image-20240830-002839

 

3. Click Create folder.


image-20240830-002852

 

4. Type any name(json_files for example) and Click "Create"

image-20240830-002903

5. Double-click "Json_files"

image-20240830-002917

 6. Click on Upload

image-20240830-002928

7. Click "Browse Files”. Select the json files from your local


image-20240830-002949

 

8. After confirming click on "NDP Fabric Builder"  from the top panel and click on the "+" button next to Virtual File Sources

image-20240830-003029

9. After creating a container , click on the "+" button next to the container to add the file

image-20240830-003107

10. Choose your file source as "NDP File Store" and. pick the previously uploaded file

image-20240830-003127

11. Provide. table name and then "Create"

image-20240830-003142

12 Preview from the left panel to see if the data is registered and can be queried

image-20240830-003158