About Snowflake Connector for Google Analytics Aggregate Data

Note

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, page views, and analyze bounce rates for a page.

The Snowflake Connector for Google Analytics Aggregate Data enables you to automatically ingest Google Analytics 4 (GA4) data into your Snowflake account. The connector extracts aggregated data using the GA4 Reporting API.

The Snowflake Connector for Google Analytics Aggregate Data ingests aggregated data from Google Analytics reports into Snowflake. Data ingestion relies on v1 of the Google Analytics Data API.

Note

  • Snowflake Connector for Google Analytics Aggregate Data is currently only supported in AWS and Azure clouds.

  • The connector can only ingest Google Analytics 4 (GA4) report data.

  • The connector requires the date dimension to be present in a report definition.

The connector uses two ingestion modes:

  • The initial load of data occurs for each report when the report is enabled for synchronization.

    After all records are ingested, the initial load phase completes.

  • The ongoing load of data begins after the initial load has completed.

    Incremental updates occur on a regular schedule that you can configure.

The Snowflake Connector for Google Analytics Aggregate Data updates some reports in parallel and the ingestion of each individual report is an independent process.

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:

  • Snowflake Connector for Google Analytics Aggregate Data is currently only supported in AWS and Azure clouds.

  • 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.

  • 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 GA4 API may return sampled data. Currently, the connector does not indicate if ingested data has been sampled.

  • 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 that TIMESTAMP_INPUT_FORMAT is set to AUTO.

Language: English