Monitoring the Snowflake Connector for Google Analytics Aggregate Data

This section describes how to monitor the state of the Snowflake Connector for Google Analytics Aggregate Data and troubleshoot problems.

About monitoring the connector

To monitor the state of the Snowflake Connector for Google Analytics Aggregate Data and troubleshoot problems, you can access the connector’s configuration, error messages and statistics using the following database objects.

Name

Description

PUBLIC.REPORT_LIST_VIEW

The list of currently configured reports, including information about the most recent ingestion

  • Report unique id and name

  • Google Analytics property id

  • Refresh interval

  • Information about the most recent ingestion

STATE.CONNECTOR_EXECUTION_LOG

Log of events that happened during ingestion. Each ingestion of data made by the connector is logged to this table

  • Log timestamp - timestamp at which the event occured

  • Property id - GA property for which the report is defined

  • Started at - start of a single ingestion cycle

  • Refreshed at - end of a single ingestion cycle

  • Number of rows - how many rows were fetched during the ingestion

  • GA Request - the GA API request

  • Error message - error message when something failed, NULL indicates a successful ingestion

These objects can be accessed by the ADMIN and VIEWER application roles defined by the connector.