Monitoring the Snowflake Connector for Google Analytics Aggregate Data

The Snowflake connector for Google Analytics Aggregate Data is subject to the Connector Terms.

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

PUBLIC.CONNECTOR_STATS

The list providing the data about finished ingestion runs.

  • Resource ingestion definition id - unique report id

  • Ingestion configuration id - always STANDARD

  • Ingestion process id - always NULL

  • Resource name - report name

  • Started at - start of a single ingestion run

  • Updated at - last update time

  • Completed at - end of a single ingestion run

  • Status - status of ingestion run, can have values COMPLETED or FAILED

  • Ingested rows - how many rows were fetched during the ingestion

  • Duration in seconds - duration of ingestion (difference between started at and completed at in seconds)

  • Throughput in rows per seconds - number of ingested rows divided by duration

PUBLIC.CONNECTOR_ERRORS

The listing storing application error logs.

  • Code - error code

  • Message - Readable message as a string

  • Created_at - timestamp when log was created

  • context - payload defining the error context

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

Language: English