Troubleshooting the Snowflake Connector for Google Analytics Aggregate Data¶

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

This topic provides guidelines for troubleshooting issues with 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 can help you determine the root cause of an issue. This procedure may be called on the connector in any state (configured, not configured, running, paused, and so on).

Note

To report an issue with the connector to snowflake Support, attach the output from this procedure.

GET_TROUBLESHOOTING_DATA takes two parameters: a ‘from’ timestamp and a ‘to’ timestamp. They limit the returned 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());

Copy

Verifying the connection to Google Analytics¶

To verify that the connector 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();

Copy

Checking the connector 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;

Copy

For information about returned content, see Monitoring the Snowflake Connector for Google Analytics Aggregate Data.