Connect Data
How to plug in or upload data sources.
Upload files or connect a live data source. RootCause supports local files, databases, data warehouses, cloud storage, and APIs. This page covers the happy path; the full detail lives in Data Sources & Connectors.
The Import Manager
You can access the import manager to upload or connect data from two places.
In a workspace, open the Sources tab and click Import data.
At organisation level, go to Manage → Data sources to see every dataset in your organisation, then click Import data in the top right.
New Import Tab

All Sources
Local File Upload
Upload files from your computer. Use it for anything that won't change. See Local Uploads.
From Organization
Reuse a dataset another workspace in your organisation has already imported. Nothing is re-uploaded or re-synced.
Foundational Ontologies Library
Use a ready-made ontology and the licensed data behind it, so you can model drivers your own data doesn't contain. See Foundational Ontologies.
Extract from Documents (Opt-in)
Turn documents you've already uploaded, such as contracts and reports, into structured tables. See Documents.
Web Research
Extract data from the web, either from tables on a page or from a prompt.
Connectors
Database
Database
Database
Database
Data warehouse
Data warehouse
Cloud storage
Cloud storage
Cloud storage
Cloud storage
API
Live Data Sync
Set each connected source to sync manually, hourly, daily, weekly, or monthly. A sync re-reads the source and updates every Dataset and analysis built on it. Connectors also offer rolling-window imports and a direct-query mode; see Connectors.
File Upload
RootCause accepts tabular files, documents and images.
Tabular
CSV, Excel, Parquet, JSON, JSONL, NDJSON
Documents
PDF, Word, PowerPoint, Markdown, text
Images (Beta)
JPG, PNG
In the Import Manager, click Local File Upload
Drag files or whole folders anywhere onto the drop zone, or use Browse files to pick individual files and Browse folder to upload everything inside a folder
Check the staged list. It shows each file's format and size, plus a total. Remove a file with ×
Choose how concepts are handled:
Auto-extract (default) pulls concepts from every file and matches them to your schema automatically
Bind to schema skips extraction. You bind each file in the upload to your schema yourself after it lands
Click Upload (n)

Current Imports Tab
Current Imports shows the imports from this session, with their progress, row and column counts, and any errors. To see every dataset in the workspace, close the Import Manager and use the Sources page.

What Happens After Upload?
The platform builds an ontology as the import runs, linking your datasets together. Build Ontology covers reviewing the detected concepts, merging columns that mean the same thing, and classifying identifiers and time fields.
Last updated

