Monitoring the connector¶
The Snowflake connector for ServiceNow® is subject to the Connector Terms.
This topic describes how to monitor the state of the Snowflake Connector for ServiceNow® and troubleshoot problems.
About Monitoring the Connector¶
To monitor the state of the Snowflake Connector for ServiceNow® and troubleshoot problems, you can access
the connector configuration, error messages and statistics through the following views, which are defined
in the PUBLIC
schema in
the database that serves an instance of the connector:
View Name |
Description |
---|---|
|
Provides access to the errors that occurred during data ingestion. |
|
Provides general information about the connector. |
|
Provides statistics about the ongoing data ingestion process and the amount of data collected by connector. |
|
Provides a list of the values of the configuration settings used by the connector. |
|
Provides the list of ServiceNow tables that are enabled or disabled for synchronization. You can use this view to determine which tables are enabled for synchronization. |
|
Provides access to information about the tables that have been enabled for synchronization. This information includes:
|
|
Provides access to information about currently ingested tables and number of rows they contain. |
Please note that all the timestamps displayed in the above views are provided in the UTC timezone with no offset, which may differ from the timezone of the dates displayed by the ServiceNow instance.
The following roles have access to these views:
The ACCOUNTADMIN system role.
The role that you have delegated configuration privileges to, for example the
connector_config_role
role.
Configuring Email Alerts¶
You can enable email alerts for the connector. The connector uses the Notification System Stored Procedure to send the email notifications. These email notifications include:
The number of errors encountered and the type of each error.
Announcements when new versions of the connector are available.
Reminders about refreshing OAuth tokens.
Enabling Email Notifications Using Snowsight¶
To configure email alerts, navigate to the Snowflake Connector for ServiceNow® application in the Marketplace:
Sign in to Snowsight as a user with the ACCOUNTADMIN role.
In the navigation menu, select Data Products » Marketplace.
Search for the Snowflake Connector for ServiceNow®, then select the tile for the connector.
In the page for the Snowflake Connector for ServiceNow®, select the tile with the title Email Alerts.
Enter the following information in the dialog box:
Field
Description
Email Address
Single email address where alerts should be sent. You must specify an email address that is associated with the Snowflake account.
Frequency
There are two possible values:
Immediately - An email message is sent immediately when an error occurs.
Once per day - An email message with a summary of all errors is sent once a day. Recommended option when custom scheduling is used.
Disabling Email Notifications Using Snowsight¶
To disable email alerts, navigate to the Snowflake Connector for ServiceNow® application in Marketplace:
Sign in to Snowsight as a user with the ACCOUNTADMIN role.
In the navigation menu, select Data Products » Marketplace.
Search for the Snowflake Connector for ServiceNow®, then select the tile for the connector.
In the page for the Snowflake Connector for ServiceNow®, select Email Alerts.
Select the … button, then select Stop Receiving Alerts.
Select Confirm.
Under the hood, the SERVICENOW_GZSTZTP0KHD_NOTIFICATION
notification integration object, used to send email
alerts, is created. The connector references this object by name. Changing name of this object or dropping it
causes the email alerts functionality to break.
Enabling Email Notifications Using SQL¶
To configure email alerts, you must create a notification integration.
After creating the notification integration, you must grant USAGE on this integration to the connector role by running:
GRANT USAGE ON INTEGRATION <notification_integration_name> TO ROLE <connector_resources_provider>;
To configure and enable email alerts, call the CONFIGURE_ALERTS
procedure:
CALL CONFIGURE_ALERTS({ 'notificationIntegrationName': '<notification_integration_name>', 'emailAddresses': ['<email_address>'], 'scheduleType': '<schedule>' });
Where:
notification_integration_name
Identifier for the notification integration that you created for sending the email alerts.
email_address
Email address where the email notifications should be sent.
You can specify only one email address.
The email address must be specified in the ALLOWED_RECIPIENTS clause of the notification integration.
schedule
The frequency with which notifications should be sent. Specify one of the following values:
ONCE_PER_DAY: Send email notifications once per day. Recommended option when custom scheduling is used.
LOWEST_INGESTION_SCHEDULE: Send email notifications as often as the least frequent scheduled synchronization.
For example, if you defined a role for your connector named SN_ROLE
, use the notification integration SN_EMAILS
to send daily email notifications to john.doe@snowflake.com
email, run the following command:
GRANT USAGE ON INTEGRATION SN_EMAILS TO ROLE SN_ROLE; CALL CONFIGURE_ALERTS({ 'notificationIntegrationName': 'SN_EMAILS', 'emailAddresses': ['john.doe@snowflake.com'], 'scheduleType': 'ONCE_PER_DAY' });
The connector references notification integration object by name. Changing the name of this object or dropping it causes the email alerts functionality to break.
Disabling Email Notifications Using SQL¶
To disable email notifications, call the DISABLE_ALERTS()
stored procedure:
CALL DISABLE_ALERTS();
If you need to enable email notifications again, see Enabling Email Notifications Using Snowsight.