Manage the Snowflake Connector for SharePoint

Note

The Snowflake Connector for SharePoint is subject to the Connector Terms.

This topics contains information about managing your Snowflake Connector for SharePoint.

You can perform the following tasks to manage the connector:

  • Modify the refresh frequency

  • Pause or resume the connector

  • View the list of source folders

Modify the refresh frequency

You can modify the refresh frequency to refresh content, metadata and permissions every day, every week, or every month.

To modify the refresh frequency, do the following:

  1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

  2. In the navigation menu, select Data sync » Manage Content Refresh.

  3. Click Edit.

  4. In the Refresh drop-down list, select either every day, every week, or every month.

You can perform refresh on-demand by running the following SQL command:

CALL PUBLIC.REFRESH_SHAREPOINT_CONTENT();
Copy

Note

You must have been assigned the role ACCOUNTADMIN to call the PUBLIC.REFRESH_SHAREPOINT_CONTENT procedure.

Pause or resume the connector

Pausing the connector only pauses the data ingestion from SharePoint and the processing with the document parsing function of Cortex, and not the Cortex Search service. The Cortex Search service continues to process previously ingested data. Pausing the connector may still result in credits consumed by Cortex Search.

Once you resume the connector, the data ingestion and processing restarts and the connector fetches all changes to files, metadata and permissions since the previous refresh. The connector also refreshes Cortex Search to use the latest content and permissions.

To pause or resume the connector, do the following:

  1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

  2. In the navigation menu, select Data sync » Manage Content Refresh.

  3. Select Pause or Resume.

View source folders list

To view the list of folders from which the connector ingests your data:

  1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

  2. In the navigation menu, Data sync » Manage Content Refresh.

All the folders that are currently configured are displayed. You can only view the folders and not specific files within those folders. All the supported files in these folders and their sub-folders are ingested, processed, and made available for use with Cortex Search, if configured.

Next step

Monitor the Snowflake Connector for SharePoint.