About the Snowflake Connector for Google Analytics Aggregate Data¶
The Snowflake connector for Google Analytics Aggregate Data is subject to the Connector Terms.
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 Aggregate Data enables you to automatically ingest aggregated data from Google Analytics 4 (GA4) reports into your Snowflake account. The connector extracts aggregated data using the GA4 Reporting API.
Data ingestion relies on v1 of the Google Analytics Data API. For more information about ingestion model, see Snowflake Connector for Google Analytics Aggregate Data ingestion model.
Note
The connector can only ingest Google Analytics 4 (GA4) report data.
The connector requires the
date
dimension to be present in a report definition.
For release note information, see Snowflake Connector for Google Analytics Aggregate Data release notes.
Limitations¶
The Snowflake Connector for Google Analytics Aggregate Data has the following limitations:
Accounts in government regions are not supported.
Only one instance of the connector is supported per Snowflake account. To install multiple instances of the connector, you must create a separate account for each connector. A single connector can ingest data from multiple GA properties, as long as the configured credentials have access to those properties.
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.
The connector can only retrieve data for Google Analytics 4 (GA4) properties. Universal Analytics (UA) are not supported.
The data in Google Analytics might change up to 72 hours after it is recorded. Currently, the connector cannot reflect the changes in real time.
The Snowflake Connector for Google Analytics Aggregate Data is not supported with Snowflake trial accounts due to external access security concerns.
The Snowflake Connector for Google Analytics Aggregate Data creates tables and views for the ingested data in a database and schema chosen by the user. Currently, the connector must have ownership of those tables and views. There must be no future ownership grants on the database or schema, and the schema must not have managed access enabled.
Users can configure at most 40 reports. Currently, this limit cannot be increased.
AUTOCOMMIT must be enabled to configure and use the connector.
Currently, the connector requires the TIMESTAMP_INPUT_FORMAT to be set to AUTO.
If the warehouse used by the connector has STATEMENT_TIMEOUT_IN_SECONDS set, it must be set to a minimum of 4 hours.