Loading data from CSV / Excel / JSON / Parquet

Users can upload multiple CSV, Excel, JSON, and/or parquet files into a PersivX workspace. Relationships (similar to SQL Foreign Keys) between files can be defined manually or automatically through PersivX's fuzzy logic feature, available in the Relationship Manager panel.

If an Excel workbook contains multiple worksheets, each worksheet will be loaded as a separate table within the workspace.

Note

Rows containing errors—such as missing columns, invalid data, or incompatible data types—will be skipped during the file loading process.

Note

Uploading a file with the same name will replace any existing file in the workspace.

Once uploaded, auto refresh can also be setup that allows periodic updates using user uploads / pulling files from external servers and loading the data into PersivX workspace.

Steps to connect:

Step 1: Select file type

Step 2: Upload 1 or more files