Installing and configuring the Snowflake Connector for Google Analytics Aggregate Data

This topic provides information on installing and configuring the Snowflake Connector for Google Analytics Aggregate Data through Snowsight.

Installing the Snowflake Connector for Google Analytics Aggregate 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 Aggregate Data, then select the tile for the connector.

  4. In the page for the Snowflake Connector for Google Analytics Aggregate 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.

Configuring the Snowflake Connector for Google Analytics Aggregate 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 Aggregate 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

    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 (for example, 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 existing one.

    Specify a name that is unique for your account. The name of the warehouse must be a valid object identifier.

    The configuration process creates a new X-Small warehouse with the specified name.

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

    This role is granted read access to tables and views containing the Google Analytics data ingested by the connector.

    The name of the role must be a valid object identifier.

    The configuration process creates a new role with the specified name.

    Alternatively you can select an existing role

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

  6. Specify authentication

    The Snowflake Connector for Google Analytics Aggregate Data supports two methods of authenticating in Google Analytics - service accounts and OAuth2. Each method requires additional configuration in your GCP project.

    For more information on how to configure each authentication see:

    For a service account, populate the following fields:

    Field

    Description

    Client email

    Google service account email which was generated during service account creation process in your Google Cloud Platform project.

    Private key

    Private key which was generated during service account creation process in your Google Cloud Platform project.

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

    For Oauth2, populate the following fields:

    Field

    Description

    Client id

    Client ID which was generated in your Google Cloud Platform project.

    Client secret

    Client secret which was generated for the client ID.

    Select Connect

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

    After successfully connecting, the connector verifies if it can access Google Analytics data. If there are any errors, you will be provided with additional instructions.

    After the process completes successfully, ingestion configuration can begin. For more information see Setting up data ingestion for your Snowflake Connector for Google Analytics Aggregate Data instance