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

Before installing the Snowflake connector for Snowflake Connector for Google Analytics Raw Data:

  • Ensure your Google account has access to both Google Analytics and Google Cloud Platform.

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

  • Configure the BigQuery link for each GA4 property you want to load to Snowflake. The link enables the GA4 raw data extraction to the GCP project. For details, see Configuring BigQuery Link for Google Analytics 4 property.

  • Create a Service Account key for your GCP project. The Snowflake connector for Snowflake Connector for Google Analytics Raw Data uses the service account to authenticate to the GCP project and read the GA4 data from the BigQuery storage. 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 for your GCP project. For details, see Configuring OAuth authentication for Google Cloud Platform (GCP).

  • Configure the OAuth consent screen and client ID for your GCP project. The Snowflake Connector for Google Analytics Raw Data uses the OAuth consent screen and the client ID to authenticate to the GCP project and read the GA4 data from the BigQuery storage. For details, see Configuring OAuth authentication for Google Cloud Platform (GCP).

  • Ensure that the Cloud Resource Manager API is enabled for your GCP project. It allows the connector to list the GA4 properties available in your GCP project.