Troubleshooting the Snowflake Connector for Google Analytics Aggregate Data

This topic provides guidelines for troubleshooting issues with the Snowflake Connector for Google Analytics Aggregate Data.

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();
Copy

Checking the execution log

If you encounter problems with data ingestion, you can check the CONNECTOR_EXECUTION_LOG table from the STATE schema in the connector’s installation database.

SELECT * FROM STATE.CONNECTOR_EXECUTION_LOG;
Copy

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