Snowflake Connector for Google Analytics Aggregate Data のモニター¶

このセクションでは、 Snowflake Connector for Google Analytics Aggregate Data の状態をモニターする方法と、問題のトラブルシューティングについて説明します。

コネクタのモニターについて¶

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.

名前	説明
`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 リフレッシュ間隔最新のインジェストに関する情報
`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

名前

説明

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
リフレッシュ間隔
最新のインジェストに関する情報

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

これらのオブジェクトは、コネクタによって定義された ADMIN および VIEWER アプリケーションロールによってアクセスできます。