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

CONNECTOR_ERRORS

Provides access to the errors that occurred during data ingestion.

CONNECTOR_OVERVIEW

Provides general information about the connector.

CONNECTOR_STATS

Provides statistics about the ongoing data ingestion process and the amount of data collected by connector.

GLOBAL_CONFIG

Provides a list of the values of the configuration settings used by the connector.

ENABLED_TABLES

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.

TABLES_STATE

Provides access to information about the tables that have been enabled for synchronization. This information includes:

  • the ingestion status.

    • DONE means that the feched data is available in the sync table.

    • RUNNING means that the download is in progress or the data is already fetched into the event log but the sync table was not updated yet.

    • FAILED means that the ingestion run was interrupted because of an error. This may result in only part of the data being downloaded. This won’t cause any data discrepancy, and depending on ingestion strategy some batches might be collected again.

    • DISABLED means that given table was disabled in the middle of this ingestion run.

  • the schedule for synchronization.

  • the timestamp of the last scheduled synchronization.

WORKERS_STATE

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:

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:

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

  2. In the navigation menu, select Data Products » Marketplace.

  3. Search for the Snowflake Connector for ServiceNow®, then select the tile for the connector.

  4. In the page for the Snowflake Connector for ServiceNow®, select the tile with the title Email Alerts.

  5. 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:

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

  2. In the navigation menu, select Data Products » Marketplace.

  3. Search for the Snowflake Connector for ServiceNow®, then select the tile for the connector.

  4. In the page for the Snowflake Connector for ServiceNow®, select Email Alerts.

  5. Select the button, then select Stop Receiving Alerts.

  6. 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>;
Copy

To configure and enable email alerts, call the CONFIGURE_ALERTS procedure:

CALL CONFIGURE_ALERTS({
  'notificationIntegrationName': '<notification_integration_name>',
  'emailAddresses': ['<email_address>'],
  'scheduleType': '<schedule>'
});
Copy

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'
});
Copy

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();
Copy

If you need to enable email notifications again, see Enabling Email Notifications Using Snowsight.