For the complete documentation index, see llms.txt. This page is also available as Markdown.

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.

  1. In a workspace, open the Sources tab and click Import data.

  2. 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

Import Manager New Import tab

All Sources

Source
What it does

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

Connector
Type

Database

Database

Database

Database

Data warehouse

Data warehouse

Cloud storage

Cloud storage

Cloud storage

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.

Type
Formats

Tabular

CSV, Excel, Parquet, JSON, JSONL, NDJSON

Documents

PDF, Word, PowerPoint, Markdown, text

Images (Beta)

JPG, PNG

  1. In the Import Manager, click Local File Upload

  2. 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

  3. Check the staged list. It shows each file's format and size, plus a total. Remove a file with ×

  4. 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

  5. Click Upload (n)

Local File Upload with staged files

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.

Current Imports tab

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