Installing and configuring the Snowflake Connector for Google Analytics Raw Data¶

Installing the Snowflake Connector for Google Analytics Raw Data¶

To install the connector, do the following:

1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

2. In the navigation menu, select Data Products » Marketplace.

3. Search for the Snowflake Connector for Google Analytics Raw Data, then select the tile for the connector.

4. In the page for the Snowflake Connector for Google Analytics Raw Data, select Get.

   This displays a dialog box that you use to begin the initial part of the installation process.

   In the dialog box configure the following:

   1. In the Options->Application name field, enter the database to use as the database for the connector instance. This database is created for you automatically.

   2. In the Warehouse used for installation field, select the warehouse that you want to use for installing the connector.

      Note

      This is not the same warehouse that is used by the connector to synchronize data from Google Analytics. In a later step, you will create a separate warehouse for this purpose.

   3. Select Get.

5. Select Open.

   The dialog box closes, and the Snowflake Connector for Google Analytics Raw Data page displays the UI for configuring and managing the connector.

Configuring the Snowflake Connector for Google Analytics Raw Data¶

To configure the connector, do the following:

1. Sign in to Snowsight as a user with the ACCOUNTADMIN role.

2. In the navigation menu, select Data Products » Apps.

3. Select the Snowflake Connector for Google Analytics Raw Data.

   The configuration wizard starts.

4. Prerequisites

   1. Make sure all prerequisites from the list are met and mark them done.

   2. Click Start configuration

5. Configure warehouse, database, schema and role

   Note

   By default, the fields are set to the names of objects that are created when you configure the connector. Snowflake recommends using new objects for these fields. However, you can specify the names of existing objects, if needed (e.g. if you are reinstalling the connector).

   Populate the following fields and select Configure at the bottom of the screen:

   Field	Description
   Warehouse	Enter the identifier for a new, dedicated virtual warehouse for the connector or select an existing one. Specify a name that is unique for your account. The name of the warehouse must be a valid object identifier. Note Do not specify the same warehouse that you selected at the beginning of the connector installation. The configuration process creates a new X-Small warehouse with the specified name. Alternatively you can select an existing warehouse.
   Destination Database	Identifier for a new database that will contain the schema with the tables for the Google Analytics data in Snowflake. Data downloaded from Google Analytics will land here. Specify a name that is unique for your account. The name of the database must be a valid object identifier. The configuration process creates a new database with the specified name. Alternatively you can select an existing database.
   Destination Schema	Identifier for a new schema that will contain the Google Analytics data in Snowflake. The Snowflake Connector for Google Analytics Raw Data ingests Google Analytics data into tables in this schema. The name of the schema must be a valid object identifier. The configuration process creates a new schema with the specified name. Alternatively you can select an existing schema.
   Role	Identifier for a new custom role for the connector. Specify a name that is unique for your account. The name of the role must be a valid object identifier. The role is an account-level role that will have read access to the ingested data. Alternatively you can select an existing role.

   If existing destination database and schema were provided, ownership of the existing regular tables and views will be transferred to the Snowflake Connector for Google Analytics Raw Data. That excludes, for example, external tables and materialized views. Moreover nothing will be transferred in managed schemas.

   It can take some time for the configuration process to complete. When the configuration process finishes successfully, the configuration wizard advances to Authentication.

6. Configure authentication

   The Snowflake Connector for Google Analytics Raw Data support two authentication methods - OAuth and Service Accounts. Each of methods requires additional configuration in your GCP project.

   For more information on how to configure each authentication see:

   • Configuring service account authentication for Google Cloud Platform (GCP)

   • Configuring OAuth authentication for Google Cloud Platform (GCP)

   If using authentication method Service Account, provide a JSON file with Service Account credentials.

   Alternatively you can populate the following fields:

   Field	Description
   Client email	Google service account email which was generated during service account creation process in Google Cloud Platform project.
   Private key	Private key which was generated during service account creation process in Google Cloud Platform project.

   Ensure you have removed the —–BEGIN PRIVATE KEY—–, —–END PRIVATE KEY—–, and \n symbols.

   If using authentication method Oauth2, populate the following fields:

   Field	Description
   Client id	Client ID generated in Google Cloud Platform project.
   Client secret	Client secret ID generated in Google Cloud Platform project.

   Select Connect

   If you have selected Oauth2 authentication, you will be presented with the Google OAuth2 authentication dialog flow.

   In the dialog, log in to Google to complete the Google OAuth2 authentication flow.

   It can take some time for the authentication process to complete.

7. Validate source

After successfully connection, the conenctor will verify that it can access the Google Analytics data. On error, the connector will guide you with additional instruction.

If the process completes successfully you can start configuring ingestion. For more information see Setting up data ingestion for your Snowflake Connector for Google Analytics Raw Data