About the Snowflake Connector for Google Analytics Raw Data

Google Analytics is a cloud-based tool that provides insight into how users interact with your website. You can use it to analyze user actions, track the number of visitors and page views, and analyze bounce rates for a page.

The Snowflake Connector for Google Analytics Raw Data enables you to automatically ingest event-level Google Analytics 4 (GA4) data into your Snowflake account. If you want to extract aggregated report data, see the section About Snowflake Connector for Google Analytics Aggregate Data and the GA4 Reporting API.

To extract Snowflake Connector for Google Analytics Raw Data – the granular, event-level details – you must set up a manual link between a GA4 property and a Google Cloud Platform (GCP) project. This enables the export of raw data into BigQuery. The Snowflake Connector for Google Analytics Raw Data then connects to the BigQuery Storage API, and downloads the data into your Snowflake account.

The high-level architecture diagram of the |GARD| Connector

The Snowflake Connector for Google Analytics Raw Data ingests data to the selected destination database and schema. Tables and views containing your Google Analytics 4 data within that schema are temporarily owned by the connector, for as long as the connector is installed. If you want to uninstall, but do not want to lose your data, please see the Uninstalling and reinstalling the Snowflake Connector for Google Analytics Raw Data section and read about the data ownership transfer during uninstallation.

For release note information, see Snowflake Connector for Google Analytics Raw Data release notes.

Known limitations

The Snowflake Connector for Google Analytics Raw Data has the following limitations:

  • Accounts in government regions are not supported.

  • You can install only one instance of the connector for each Snowflake account. To install multiple instances of the connector, you must create a separate account for each connector.

  • Parameter AUTOCOMMIT has to be enabled.

  • To install and configure the connector, you must be logged in as a user with the ACCOUNTADMIN role. Other roles are not supported at this time.

  • Emojis are not supported as parts of the application name set during connector installation.

  • The connector can retrieve data for Google Analytics 4 (GA4) properties only. Universal Analytics (UA) is not supported.

  • The data in Google Analytics can change up to 72 hours after recording. Currently, the connector doesn’t reflect the changes in real time.

  • The Snowflake Connector for Google Analytics Raw Data does not support custom (other than default) date formats.

  • The Snowflake Connector for Google Analytics Raw Data is supported in the AWS environment and is becoming available in Azure. GCP is not currently supported.

  • The Snowflake Connector for Google Analytics Raw Data does not work on Snowflake trial accounts due to external access security concerns. This is not expected to change in the future.

  • The Snowflake Connector for Google Analytics Raw Data assumes that the application is the owner (has OWNERSHIP privilege) of all tables and views in destination schema. Granting FUTURE OWNERSHIP privilege on tables or views in this SCHEMA/DATABASE might result in connector not working correctly.

  • The Snowflake Connector for Google Analytics Raw Data does not

Language: English