Setting up data ingestion for your Snowflake Connector for Google Analytics Aggregate Data instance¶
The Snowflake connector for Google Analytics Aggregate Data is subject to the Connector Terms.
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:
Sign in to Snowsight as a user with the ACCOUNTADMIN role.
In the navigation menu, select Data Products » Apps.
Search for the Snowflake Connector for Snowflake Connector for Google Analytics Aggregate Data, then select the tile for the connector
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 thedate
dimension in all reports.Note
The dimensions field shows up after choosing the Google Analytics property. At most 9 dimensions can be configured.
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. At most 10 metrics can be configured.
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.
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:
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.
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.