Downloads 77this week

GitHub stars 2

Extension descriptor (YAML)

Query files in SharePoint / OneDrive directly with a sharepoint:// filesystem

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Installing and Loading

INSTALL sharepoint FROM community;
LOAD sharepoint;

Example

-- App-only auth: an Entra ID app registration with the Sites.ReadWrite.All
-- APPLICATION permission and admin consent. Bind it to a document library
-- by DRIVE_ID (a Graph drive id) or SITE_ID.
CREATE SECRET sp (
    TYPE sharepoint,
    PROVIDER client_credentials,
    TENANT_ID '00000000-0000-0000-0000-000000000000',
    CLIENT_ID '11111111-1111-1111-1111-111111111111',
    CLIENT_SECRET '...',
    DRIVE_ID 'b!AbCdEf...'
);

-- Read a file by path -- one Graph call, no per-segment walk.
SELECT count(*) FROM 'sharepoint://Finance/2026/actuals.parquet';

-- Address by driveItem id instead -- stable across a rename.
SELECT * FROM read_csv('sharepoint://id:01ABCDEF23456789');

-- Glob a folder.
SELECT * FROM read_parquet('sharepoint://exports/parts/*.parquet');

-- Write a file. Sequential only; streamed in bounded memory.
COPY (SELECT * FROM t) TO 'sharepoint://reports/out.parquet' (FORMAT parquet);

About sharepoint

Registers a sharepoint:// filesystem backed by Microsoft Graph, so any DuckDB path expression can address a file in a SharePoint document library or OneDrive with no download step. Because DuckDB dispatches file access through its virtual filesystem, read_parquet, read_csv, COPY, glob and DuckLake all inherit the scheme.

Unlike Google Drive, Graph addresses items by path, so there is no path-resolution cache and no duplicate-name ambiguity. Reads are ranged and served from a block cache. Writes stream through a Graph upload session in bounded memory and the file appears when it is closed (Graph cannot write at a byte offset, so positional writes raise rather than corrupt). Besides app-only client credentials, a user can sign in with device_code or authorization_code. Also registers the scheme-generic write_blob, remove_file, move_file and file_size SQL functions, which work for any filesystem DuckDB can reach.

This is SharePoint / OneDrive via Microsoft Graph, not Azure Blob Storage — a different product with a different API. For az:///abfss:// containers use the azure extension.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings