---
title: "Connect OneDrive to Rig — Rig guide"
description: "Connect OneDrive to Rig by signing in with Microsoft, and sync tabular files and documents from one folder into your warehouse."
canonical: "https://rig.so/guides/connect-onedrive"
format: markdown
---

Search guides, references, playbooks…⌘K

Browse guides

# Connect OneDrive to Rig

Rig reads the files in a OneDrive folder through Microsoft Graph. Each tabular file becomes its own table, and PDFs, Word and text files go into a versioned documents table. You sign in with Microsoft, so there is no key to create.

Availability
Rig enables this connection on request. [Contact us](https://rig.so/contact) and we will turn it on for your workspace.

## Before you start

- You need a Microsoft account that can open the folder you want to sync.
- Find the folder's item ID if you want a single folder. Leave it blank to scan the root of the drive.

## Connect it in Rig

New to Rig? Watch how to find Connections

Adding a source needs a workspace owner, or a role with the Manage connections permission, on a workspace where you manage your own connections. If the Connectors tab says “Data ingestion for this workspace is managed by Rig”, ask an owner or Rig support to add the source.

1. In Rig, open `Connections`, choose the `Connectors` tab and go to `Sources & actions`.
2. Search for **OneDrive**, open the card and click `Connect`.
3. **Folder ID (optional)**: a OneDrive folder item ID. Leave it blank to scan the drive root.
4. Click **Authorize with OneDrive**, sign in and approve the consent screen, then choose the streams you want.
5. The source then syncs on its schedule, which is nightly unless you change it. To load data straight away, click `Sync` on its row; `Test` pulls a small sample first if you want to check the connection.

## What Rig pulls in

OneDrive lands in its own `onedrive` schema in your warehouse:

- **Tabular files**: CSV, Parquet and JSONL files each land as their own table.
- **Documents**: PDFs, Word (.docx) and Markdown or text files land in one versioned `documents` table, with one row per PDF page and one row per Word or text file.

Streams are the files Rig finds, so there is no stream list to choose from.

## Good to know

- Rig reads the one folder you name, identified by its Microsoft Graph item ID. Microsoft's List children reference shows how to list a folder's items and their IDs.
- When a document changes, Rig appends a new version rather than overwriting the old one.
- Rig asks for the Files.Read permission plus offline access, which lets syncs run without you signing in each time. It never asks to change your files.
- To disconnect OneDrive, click the bin icon on the source's row under `Sources & actions`. Only whoever connected the source or a workspace owner can do this, and data already synced stays in the warehouse.

## What people use this for

- Ingest CSV and Parquet files from OneDrive
- Centralise finance and ops files
- Make document contents searchable

[More ideas for using OneDrive](https://rig.so/integrations/onedrive)

## OneDrive documentation

- [List the contents of a folder, Microsoft Graph](https://learn.microsoft.com/en-us/graph/api/driveitem-list-children?view=graph-rest-1.0)
- [driveItem resource type](https://learn.microsoft.com/en-us/graph/api/resources/driveitem?view=graph-rest-1.0)

Was this guide helpful?

Yes No

---

- [This page as HTML](https://rig.so/guides/connect-onedrive)
- [Site map for language models](https://rig.so/llms.txt)
- [API and agent documentation](https://rig.so/developers)