DQC Logo
|

Upload static files (CSV, Excel, Parquet, JSON)

In addition to live database connectors, the DQC Platform lets you upload static files directly. Each upload becomes its own connector with one table — useful for one-off checks, sample data or data feeds you receive as files.


Add a file connector

  1. Go to the Connectors > Data sources screen

  2. Pick the tile that matches your file type: CSV, Excel, Parquet or JSON

  3. Enter a Table Name, select the file to upload, and submit

Table names may only contain letters, digits, spaces, dashes and underscores. All uploads are stored encrypted on the platform's storage backend.


undefined Supported file types

Type

Extensions

Notes

CSV

.csv

Encoding is auto-detected and converted to UTF-8. Delimiter can be auto-detected or selected manually (see below).

Excel

.xlsx

Only the first sheet is imported. Legacy .xls files are not supported — re-save them as .xlsx.

Parquet

.parquet

Imported as-is. Schema and data types are preserved.

JSON

.json

A flat list of objects works best. DQC flattens shallow {field: {value: X}} wrappers automatically; deeply nested structures should be flattened beforehand.

Maximum file size: 100 MB by default.


undefined CSV — delimiter handling

When uploading a CSV file you choose a delimiter:

  • automatic — DQC sniffs the delimiter from the first lines (recommended for most files)

  • comma (,), semicolon (;), colon (:), pipe (|), tilde (~), caret (^)

  • custom — enter any single character if your file uses a different separator

Each CSV table within a connector remembers its own delimiter, so you can mix files with different separators in the same workspace.


undefined Updating an existing file table

Open the file connector, choose the table you want to refresh and upload a new file. DQC replaces the table contents atomically — checks and rules already attached to the table remain valid as long as column names match.


undefined Connect and assign permissions

To control who can view and use uploaded files inside DQC, see Data source access permissions.