Microsoft SharePoint integration
Microsoft SharePoint data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.table
type: ingestr
parameters:
source_connection: microsoft_sharepoint
source_table: '<table>'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/microsoft_sharepoint.asset.yml
- extract · Microsoft SharePoint dataincremental
- load · snowflake raw.datamerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
SharePoint Online is Microsoft's document management and collaboration platform. ingestr can read files (Excel and CSV) from a SharePoint document library through the Microsoft Graph API. Each file (or glob of files) is landed as raw rows. Cell values are kept as text and a few extra columns are added to record each row's source file, sheet, and position.
- 01
Add a Microsoft SharePoint connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- tenantid
- Azure AD tenant ID of the app registration
- clientid
- app registration (service principal) client ID
- clientsecret
- app registration client secret
- hostname
- SharePoint tenant hostname, e.g. example.sharepoint.com
- site
- server-relative site path, e.g. sites/Example
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
01 · Move
02 · Model & govern
03 · Use
Frequently asked
Questions about Microsoft SharePoint.
Does Bruin have a built-in Microsoft SharePoint integration?
Yes. Built-in ingestr source.
Where can Microsoft SharePoint data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Microsoft SharePoint?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.