Setting up data ingestion for your Snowflake Connector for Google Analytics Aggregate Data instance

This section describes how to access Snowflake Connector for Google Analytics Aggregate Data in your Snowflake account.

Adding reports in the connector

To set up data ingestion using Snowsight, 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. Search for the Snowflake Connector for Snowflake Connector for Google Analytics Aggregate Data, then select the tile for the connector

  4. In the Data sync section, select Add report.

    This displays a new dialog box.

    In this dialog box, fill in the following fields:

    Field

    Description

    Report name

    Identifier for the new report.

    Specify a name that is unique for your destination schema. The name of the report must follow the naming rules for unquoted object identifiers.

    Property

    A Google Analytics property that holds the data you want to ingest.

    Choose one of the available Google Analytics properties.

    Note

    If a Google Analytics property that you would like to use is not available, check whether the credentials used by the connector have access to it. For more details, see Preparing your Google Analytics and Google Cloud Platform (GCP) accounts.

    Dimensions

    Google Analytics 4 dimensions that you want to appear in your report.

    Dimensions are attributes of your data. For example, the dimension city indicates the city from which an event originates. The connector includes the date dimension in all reports.

    Note

    The dimensions field shows up after choosing the Google Analytics property.

    For more details about the available dimensions, see API Dimensions & Metrics.

    Metrics

    Google Analytics 4 metrics that you want to appear in your report.

    Metrics are quantitative measurements of a report. For example, the metric active1DayUsers is the number of distinct active users on your site or app within a 1 day period. You must select at least one metric.

    Note

    The metrics field shows up after choosing the Google Analytics property.

    For more details about the available metrics, see API Dimensions & Metrics.

    Keep empty rows

    If selected, the ingested data should contain records with dimension combinations for which all the metrics are zero (indicating that there were no events correlated with those dimensions).

    Note

    It’s not guaranteed that all dimension combinations will be present in the ingested data.

    Sync data from

    Start date for the initial load of data.

    Sync schedule

    Sync frequency for the ongoing load of data.

  5. Select Start Sync.

    It can take a few minutes for the ingestion process to complete. The table and view with your report data will not be visible in the destination database until the data from GA is fully fetched.

Deleting reports from the connector

To delete an existing report from the connector, do the following:

  1. In the Data sync section, select trash bin icon next to a report that you want to delete.

    This displays a confirmation dialog asking you to confirm you want to delete the selected report.

  2. Select Delete Report.

    It can take a while for the delete report process to complete.

    Note

    Deleting the report does not delete the ingested data for that report.

    The confirmation dialog closes and the report is removed from the Reports section.