Connect Box to Rig

    Rig reads a Box folder and every subfolder under it. Each tabular file becomes its own table, and PDFs, Word and text files go into a versioned documents table. You authorise with your Box account, 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 Box account that can open the folder you want to sync.
    • Decide which folder to start from. Leave it blank to scan the whole account.

    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 Box, open the card and click Connect.
    3. Folder ID (optional): a Box folder address (app.box.com/folder/<ID>) or just its ID. Leave it blank to scan the account root, which is folder 0.
    4. Click Authorize with Box, 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

    Box lands in its own box 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 walks the chosen folder and all its subfolders. Pointing at the account root brings in every readable file you can see.
    • When a document changes, Rig appends a new version rather than overwriting the old one.
    • Rig asks Box for read-only access to your files and folders, and downloads each file when the sync reaches it.
    • To find a folder's ID, open the folder in Box and copy the number from the address.
    • To disconnect Box, 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

    • Query the spreadsheets the business actually runs on
    • Make document contents searchable
    • Keep a history of what changed

    More ideas for using Box

    Was this guide helpful?