Preparing your Google Analytics and Google Cloud Platform (GCP) accounts

Before installing Snowflake Connector for Google Analytics Aggregate Data:

  • Ensure your Google Analytics properties are migrated to Google Analytics 4 (GA4). The Snowflake Connector for Google Analytics Aggregate Data does not support Universal Analytics.

  • Create a Service Account key for your GCP project. The Snowflake Connector for Google Analytics Aggregate Data uses the service account to authenticate against the GA4 API. For details, see Configuring service account authentication for Google Cloud Platform (GCP). As an alternative, you can also configure the OAuth consent screen and client ID in your GCP project. For details, see Configuring OAuth authentication for Google Cloud Platform (GCP).

  • If you choose to use OAuth as an authentication method for the connector, you need to configure the OAuth consent screen and client ID in your GCP project. The Snowflake Connector for Google Analytics Aggregate Data uses the OAuth consent screen and the client ID to authenticate against the GA4 API. For details, see Configuring OAuth authentication for Google Cloud Platform (GCP).

  • Ensure that the Google Analytics Admin API and Google Analytics Data API are enabled for your GCP project.