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

    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

    Was this guide helpful?