Move Microsoft OneDrive data anywhere it matters.

Move Microsoft OneDrive data into your warehouse, lake or AI app.

Sync Microsoft OneDrive free Read the docs

Source

Microsoft OneDrive

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Standard support: 0.2.44

Overview

What is the Airbyte Microsoft OneDrive connector?

The Airbyte Microsoft OneDrive connector extracts data from Microsoft OneDrive and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land Microsoft OneDrive data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Microsoft OneDrive once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Microsoft OneDrive connector on Cloud, OSS, Hybrid.

Setup

Live in twelve steps

Navigate to the Airbyte Open Source dashboard.
Click Sources and then click + New source.
On the Set up the source page, select Microsoft OneDrive from the Source type dropdown.
Enter the name for the Microsoft OneDrive connector.
Enter Drive Name. To find your drive name go to settings and at the top of setting menu you can find the name of your drive.
Select Search Scope. Specifies the location(s) to search for files. Valid options are 'ACCESSIBLE_DRIVES' to search in the selected OneDrive drive, 'SHARED_ITEMS' for shared items the user has access to, and 'ALL' to search both. Default value is 'ALL'.
Enter Folder Path. Leave empty to search all folders of the drives. This does not apply to shared items.
The OAuth2.0 authorization method is selected by default. Click Authenticate your Microsoft OneDrive account. Log in and authorize your Microsoft account.
For Start Date, enter the date in YYYY-MM-DD format. The data added on and after this date will be replicated.
Add a stream:
Write the File Type
In the Format box, use the dropdown menu to select the format of the files you'd like to replicate. The supported formats are CSV, Parquet, Avro and JSONL. Toggling the Optional fields button within the Format box will allow you to enter additional configurations based on the selected format. For a detailed breakdown of these settings, refer to the File Format section below.

Configuration fields

Microsoft OneDrive configuration fields
Field	Type	Description
credentials*	object	Credentials for connecting to the One Drive API
streams*	array	Each instance of this configuration defines a stream. Use this to define which files belong in the stream, their format, and how they should be parsed and validated. When sending data to warehouse destination such as Snowflake or BigQuery, each stream is a separate table.
drive_name	string	Name of the Microsoft OneDrive drive where the file(s) exist.
folder_path	string	Path to a specific folder within the drives to search for files. Leave empty to search all folders of the drives. This does not apply to shared items.
search_scope	string	Specifies the location(s) to search for files. Valid options are 'ACCESSIBLE_DRIVES' to search in the selected OneDrive drive, 'SHARED_ITEMS' for shared items the user has access to, and 'ALL' to search both.
start_date	string	UTC date and time in the format 2017-01-25T00:00:00.000000Z. Any file modified before this date will not be replicated.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Microsoft OneDrive connector questions

What data can I sync from Microsoft OneDrive with Airbyte?

The Microsoft OneDrive connector syncs the tables and events published in Airbyte docs.

Does the Microsoft OneDrive connector support incremental sync?

Yes. The Microsoft OneDrive connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the Microsoft OneDrive connector?

Run the Microsoft OneDrive connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales