About the Snowflake Connector for Google Analytics Raw Data

Google Analytics 是一款基于云的工具，可以深入了解用户如何与您的网站交互。您可以使用该工具分析用户操作，跟踪访问者数量和页面浏览量，并分析页面的跳出率。

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 About the and the GA4 Reporting API (https://developers.google.com/analytics/devguides/reporting/data/v1).

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 (https://cloud.google.com/bigquery/docs/reference/storage/), and downloads the data into your Snowflake account.

The high-level architecture diagram of the Snowflake Connector for Google Analytics Raw Data

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.

已知限制

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

  • 目前不支持政府区域中的账户。
  • 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.
  • 连接器只能检索 Google Analytics 4 (GA4) 属性的数据。Universal Analytics (UA) 现在和将来都不受支持。
  • 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 the FUTURE OWNERSHIP privilege on tables or views in this SCHEMA/DATABASE, or using a managed schema, will result in connector not working correctly.
  • 必须在与连接器交互的会话中启用参数 AUTOCOMMIT。
  • 如果在账户中设置自定义日期格式，连接器将无法正常工作。
  • 对于在连接器安装过程中设置的应用程序名称，不支持将表情符号用作该名称的一部分。
  • 不支持将 Google Analytics 导出切换到其他项目。