About Openflow Connector for SharePoint¶
Note
This connector is subject to the Snowflake Connector Terms.
This topic describes the basic concepts of Openflow Connector for SharePoint, its use cases and limitations.
The Openflow Connector for SharePoint connects a Microsoft 365 SharePoint site and Snowflake to ingest files and user permissions and keeps them up to date. Openflow Connector for SharePoint also supports the Cortex Search service and can make ingested files ready for conversational analysis for use in AI Assistants using SQL, Python or REST APIs.
Variants of the Openflow Connector for SharePoint¶
The Openflow Connector for SharePoint contains four variants which allow you to, optionally, index data into Snowflake Cortex Search and include document metadata (ACLs).
Variant |
Description |
Microsoft SharePoint (Cortex Search, document ACLs) |
Indexes files and their permissions (ACLs) into Snowflake Cortex Search. |
Microsoft SharePoint (Cortex Search, no document ACLs) |
Indexes files without their permissions (ACLs) into Snowflake Cortex Search. |
Microsoft SharePoint (Simple Ingest, document ACLs) |
Ingests files and their permissions (ACLs) into a Snowflake stage. |
Microsoft SharePoint (Simple Ingest, no document ACLs) |
Ingests files without their permissions (ACLs) into a Snowflake stage. |
These variants appear as separate connectors in Marketplace. When installing the connector, choose the variant that meets your requirements.
Rate limiting restrictions¶
SharePoint API limits govern how many requests can be made within a given time frame. If your flow exceeds the allowed quota, syncs may slow down or fail with an error. This mostly occurs when your access token makes higher number of requests than the source typically allows. In such cases, Snowflake recommends applying for higher access quota (wherever applicable) or reducing the sync frequency.
Limitations¶
Changes caused by moving or renaming folders aren’t captured during incremental ingestion.
The connector ingests only the supported file types and ignores others.