Troubleshooting the Snowflake Connector for Google Analytics Raw Data

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

Verifying a connection to the Google Cloud Platform (GCP) instance

To verify that the Snowflake Connector for Google Analytics Raw Data can access the Google Cloud Platform (GCP) instance, call the CONNECTION_STATUS stored procedure, which is defined in the PUBLIC schema of the connector installation database:

CALL CONNECTION_STATUS();
Copy

To check the connection status in Snowsight, do the following:

  1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

  2. In the navigation menu, select Data Products » Apps.

  3. Select the Snowflake Connector for Google Analytics Raw Data.

The color of the icon in the Authenticate Google Cloud Platform section shows if the connection to GCP was successful. If the icon is red, the attempt to connect to GCP failed. To try reconnecting, select Reauthenticate.

If the icon is green, the connector is ready to ingest data.

Checking connector status

To examine connector status use the GET_CONNECTOR_STATUS stored procedure, as shown:

CALL PUBLIC.GET_CONNECTOR_STATUS()
Copy

Checking current ingestion status

If you’re missing data from a particular day, you can query the CONNECTOR_STATS view to see whether there have been any errors when trying to ingest that day’s table from BigQuery:

SELECT * FROM CONNECTOR_STATS WHERE PROPERTY_ID = '<property_name>' AND BIG_QUERY_TABLE = 'events_<date>' ORDER BY RUN_START_TIME DESC;
Copy

The result will show all attempts to download a particular table from BigQuery’s dataset for a particular property, with the latest one at the top. The STATUS column will show the outcome, and for any failed attempt, the ERROR_MESSAGES column will detail what happened.

Downloading connector logs

If you encounter problems with the connector, you can call the GET_TROUBLESHOOTING_DATA stored procedure, which is defined in the PUBLIC schema of the connector installation database:

CALL GET_TROUBLESHOOTING_DATA(7);
Copy

The parameter defines how many days in the past since now should be included in the logs. Please use 7 as a default unless support asks you to use a different value.

As a result, you get the full connector logs. You can download the logs, filter, and share the logs with the application provider.

Sharing connector logs from an event table with an application provider

It is possible to share connector logs stored in the event table with the application provider. This could be used by the provider to investigate encountered problems with the connector. Click this link to read more about consumer enable logging.

Note

This feature would not work without enabling event tables on the account.

To enable sharing application events from the event table run:

ALTER APPLICATION <GARD APPLICATION NAME> SET SHARE_EVENTS_WITH_PROVIDER = TRUE;
Copy

To stop sharing run:

ALTER APPLICATION <GARD APPLICATION NAME> SET SHARE_EVENTS_WITH_PROVIDER = FALSE;
Copy

Current status could be checked by running:

DESC APPLICATION <GARD APPLICATION NAME>;
Copy

Comparing row counts in Google Cloud Platform (GCP) and Snowflake

To check if the ingestion was correct, you can compare the row counts in Snowflake and Google Cloud Platform (GCP).

To check the row count in Snowflake, run the following query:

SELECT COUNT(*) FROM analytics_<property_name> WHERE source_table_date = '<date>';
Copy

To check the row count in GCP, run the following query:

SELECT COUNT(*) FROM '<project_id>.analytics_<property_name>.events_<date>';
Copy