Install and configure the Snowflake Connector for Google Analytics Aggregate Data¶

Install the Snowflake Connector for Google Analytics Aggregate Data¶

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, and then select the tile for the connector.

4. On the page for the Snowflake Connector for Google Analytics Aggregate Data, select Get.

   A dialog box is displayed.

5. Under Options, for Application name, enter a name for the database to use for the connector instance.

   This database is created for you automatically.

6. For Warehouse used for installation, select the warehouse 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 procedure, you create a separate warehouse for this purpose.

Configure the Snowflake Connector for Google Analytics Aggregate Data¶

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. Ensure that all prerequisites on the list are met, and mark them as done.

5. Click Start configuration.

6. Populate the following fields:

   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 (for example, if you are reinstalling the connector).

   Field	Description
   Warehouse	Enter the identifier for a new, dedicated virtual warehouse for the connector. 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	Enter the 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 be stored 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.
   Destination Schema	Enter the 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.
   Role	Enter the identifier for a new custom role for the connector. This role is granted read access to tables and views that contain 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.

7. Select Configure at the bottom of the screen.

   The configuration process can take several minutes. When it is finished, the wizard advances to Authentication.

8. To specify authentication, follow one of these options:

   Note

   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 Google Cloud project. For more information, see Configure service account authentication for Google Cloud and Configure OAuth authentication for Google Cloud.

   • For a service account, populate the following fields:

   Field	Description
   Client email	Google service account email that was generated during service account creation in your Google Cloud project
   Private key	Private key that was generated during service account creation in your Google Cloud project Ensure that the —–BEGIN PRIVATE KEY—–, —–END PRIVATE KEY—–, and \n symbols are removed. # pragma: allowlist secret

   • For Oauth2, populate the following fields:

   Field	Description
   Client id	Client ID that was generated in your Google Cloud project
   Client secret	Client secret that was generated for the client ID

9. Select Connect.

   If you selected Oauth2 authentication, the Google OAuth authentication dialog will open.

10. Optional: Complete the Google OAuth authentication dialog.

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

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