> For the complete documentation index, see [llms.txt](https://docs.rootcause.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.rootcause.ai/user-guide/connecting-data.md).

# 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](https://docs.rootcause.ai/data-sources-and-connectors/sources-overview.md).

***

## 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

<figure><img src="https://1662811113-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBXg3gZLR0e2Q8SzeQmql%2Fuploads%2Fgit-blob-9dbf30366a0c633a0893ef460a9525757f0bbe09%2Frc-import-manager-new-import.png?alt=media" alt="Import Manager New Import tab"><figcaption></figcaption></figure>

### **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](https://docs.rootcause.ai/data-sources-and-connectors/local-uploads.md).                                                                |
| **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](https://docs.rootcause.ai/data-sources-and-connectors/foundational-ontologies.md). |
| **Extract from Documents (Opt-in)** | Turn documents you've already uploaded, such as contracts and reports, into structured tables. See [Documents](https://docs.rootcause.ai/data-sources-and-connectors/local-uploads/document-uploads.md).                            |
| **Web Research**                    | Extract data from the web, either from tables on a page or from a prompt.                                                                                                                                                           |

### Connectors

| Connector                                                                                                        | Type           |
| ---------------------------------------------------------------------------------------------------------------- | -------------- |
| [PostgreSQL](https://docs.rootcause.ai/data-sources-and-connectors/connectors/postgresql.md)                     | Database       |
| [MySQL](https://docs.rootcause.ai/data-sources-and-connectors/connectors/mysql.md)                               | Database       |
| [ClickHouse](https://docs.rootcause.ai/data-sources-and-connectors/connectors/clickhouse.md)                     | Database       |
| [MongoDB](https://docs.rootcause.ai/data-sources-and-connectors/connectors/mongodb.md)                           | Database       |
| [Snowflake](https://docs.rootcause.ai/data-sources-and-connectors/connectors/snowflake.md)                       | Data warehouse |
| [BigQuery](https://docs.rootcause.ai/data-sources-and-connectors/connectors/bigquery.md)                         | Data warehouse |
| [Amazon S3](https://docs.rootcause.ai/data-sources-and-connectors/connectors/s3.md)                              | Cloud storage  |
| [Azure Data Lake](https://docs.rootcause.ai/data-sources-and-connectors/connectors/azure-data-lake.md)           | Cloud storage  |
| [Google Cloud Storage](https://docs.rootcause.ai/data-sources-and-connectors/connectors/google-cloud-storage.md) | Cloud storage  |
| [Google Drive](https://docs.rootcause.ai/data-sources-and-connectors/connectors/google-drive.md)                 | Cloud storage  |
| [REST API](https://docs.rootcause.ai/data-sources-and-connectors/connectors/rest-api.md)                         | 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](https://docs.rootcause.ai/data-sources-and-connectors/connectors.md).

***

## 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)**

<figure><img src="https://1662811113-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBXg3gZLR0e2Q8SzeQmql%2Fuploads%2Fgit-blob-f19791169f1de961214402ffbd41db75e1972f6a%2Frc-local-upload-staged-footer.png?alt=media" alt="Local File Upload with staged files"><figcaption></figcaption></figure>

***

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

<figure><img src="https://1662811113-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FBXg3gZLR0e2Q8SzeQmql%2Fuploads%2Fgit-blob-36b124d9e39952628c3c6f2acb75c4ddcb64bdc0%2Frc-current-imports.png?alt=media" alt="Current Imports tab"><figcaption></figcaption></figure>

***

## What Happens After Upload?

The platform builds an ontology as the import runs, linking your datasets together. [Build Ontology](https://docs.rootcause.ai/user-guide/ontology-concepts.md) covers reviewing the detected concepts, merging columns that mean the same thing, and classifying identifiers and time fields.
