Troubleshooting the Snowflake Connector for Google Analytics Aggregate Data¶

Calling the get_troubleshooting_data procedure¶

The GET_TROUBLESHOOTING_DATA procedure returns information about the configuration of a connector, ingestion history, errors, and additional information that helps to determine the root cause of a potential issue. This procedure may be called on the connector in any state (configured, not configured, running, paused, and so on).

Before reporting an issue with the connector to snowflake Support, please make sure that you have attached the output from this procedure.

GET_TROUBLESHOOTING_DATA takes two parameters: a ‘from’ timestamp and a ‘to’ timestamp. They limit the amount of rows to the relevant time frame. For example, to get troubleshooting data with an ingestion history for the last week you can call:

CALL GET_TROUBLESHOOTING_DATA(DATEADD(day, -7, SYSDATE()), SYSDATE());

Verifying the connection to Google Analytics¶

To verify that the Snowflake Connector for Google Analytics Aggregate Data can access Google Analytics data, call the TEST_CONNECTION stored procedure, which is defined in the PUBLIC schema of the connector’s installation database:

CALL TEST_CONNECTION();

Checking the connectors stats and connector errors views¶

If you encounter problems with data ingestion, you can check the CONNECTOR_STATS view and the CONNECTOR_ERRORS view from the PUBLIC schema in the connector’s installation database.

SELECT * FROM PUBLIC.CONNECTOR_STATS;
SELECT * FROM PUBLIC.CONNECTOR_ERRORS;

For information on returned content see: Monitoring the Snowflake Connector for Google Analytics Aggregate Data