OneDrive

Microsoft OneDrive is a file-hosting and synchronization service operated by Microsoft as part of its web version of Office. It allows users to store files and personal data like Windows settings or BitLocker recovery keys in the cloud, share files, and sync files across most devices and operating systems.

Feature nameSupported
Column HashingTrueField level
BlockingTrueField level
IncrementalTrue
Custom dataTrue
HistoryFalse
ReSyncTrueTable level
TemplatesFalse

The OneDrive connector requires your files to be in a dedicated folder. Weld will sync data from this folder to your destination.

🔧 Setup Guide - ELT

Step 1 - Begin Configuration

  1. In the connector setup form, enter the destination schema name of your choice.
  2. Click Authorize to give Weld access to your OneDrive files.
  3. When authorization is complete, you will be redirected back to the Weld connections overview. The configuration is complete.

Step 2 - Connection Settings

  1. Select the file type: xlsx or csv.
  2. Enter the folder URL where your files are stored.
  3. Select if you wish to use any of the options:
  • Has header row - will use the first row as column names.
  • Stringify all properties - will convert all properties to strings, in case there are any issues with the data types.

Step 4 - Data To Sync

Select which files you would like to sync.

Step 5 - Configure Sync

Select how often you would like the data to sync.

Weld will take over from here and commence syncing data from your OneDrive folder.

🔧 Setup Guide - Reverse ETL

OneDrive reverse ETL allows you to sync data on a schedule from your Weld App automatically into a file in a designated OneDrive/SharePoint folder.

Every sync creates a brand new file in the selected folder containing the full result of your model. There is no concept of inserting, updating, or upserting individual rows — each run is a fresh Mirror of your data.

Pre-requisites:

  1. You first must set up a connection to OneDrive via OAuth.
  2. You must publish your SQL model containing the data that you want to sync to OneDrive.

Step 1 - Begin Configuration

  1. Click on the Reverse ETL button in the side bar and click + New on the top right.
  2. Select the OneDrive connector from the drop down menu or else click + Add new connection to authorize the connector.

Step 2 - Destination Settings

  1. Folder URL: Enter the OneDrive/SharePoint folder URL the file will be uploaded to. To get the folder URL, navigate to the folder, then click "Share" -> "Copy link"
  2. File type: Choose the format of the generated file — CSV, Parquet, NDJSON, or JSON array.
  3. Compression: Optionally compress the file with Gzip. Not available for Parquet, since it is already internally compressed.
  4. Custom file name prefix (optional): Override the default file name prefix. If not provided, files are named weld_{id}_{timestamp}.{extension}. With a custom prefix, files are named {custom_prefix}_{timestamp}.{extension}.

Step 3 - Model

  1. Choose the SQL model that contains the data you would like to send to OneDrive.
  2. Map the model columns to the file columns. Every column will be included as is, the column name and type will be preserved to the extent the file format allows.

Step 4 - Sync Operation

OneDrive only supports Mirror: every sync creates a brand new file containing all of the data from your model.

Step 5 - Schedule

Choose how often you would like the sync to run. You can choose to have the sync running on an independent schedule or as part of an orchestration workflow.

Was this page helpful?