Monitoramento do Snowflake Connector for Google Analytics Aggregate Data

Esta seção descreve como monitorar o estado do Snowflake Connector for Google Analytics Aggregate Data e solucionar problemas.

Sobre o monitoramento do conector

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.

Nome

Descrição

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

  • Intervalo de atualização

  • Informações sobre a ingestão mais recente

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

Esses objetos podem ser acessados pelas funções de aplicativo ADMIN e VIEWER definidas pelo conector.

Linguagem: Português