Monitor the Snowflake Connector for SharePoint¶
Note
The Snowflake Connector for SharePoint is subject to the Connector Terms.
This topic describes how to monitor the state of the Snowflake Connector for SharePoint.
Views¶
To monitor the state of the Snowflake Connector for SharePoint and troubleshoot problems, view the connector configuration, error messages and statistics detailed the following views, which are defined in the PUBLIC schema of the connector application.
View |
Description |
---|---|
|
Provides information to the user interface about properties supported by the Snowflake Connector for SharePoint |
|
Provides a list of the values for configuration settings used by the connector. |
|
Provides access to errors that have occurred during data ingestion. |
|
Provides the general status of the connector and the ingestion process, and includes states:
|
Examples¶
SELECT * FROM <APPLICATION_INSTANCE_DATABASE>.PUBLIC.CONNECTOR_CONFIGURATION; SELECT * FROM <APPLICATION_INSTANCE_DATABASE>.PUBLIC.CONNECTOR_ERRORS; SELECT * FROM <APPLICATION_INSTANCE_DATABASE>.PUBLIC.SYNC_STATUS;Copy
Note that all the timestamps displayed in these views are provided in the UTC timezone with no offset.
Required roles¶
The following roles have access to the described views:
The owner of the connector application (typically the ACCOUNTADMIN system role).
Any role with ADMIN or VIEWER application role granted.