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:
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:
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.
A Google Analytics property that holds the data you want to ingest.
Choose one of the available Google Analytics properties.
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.
Google Analytics 4 dimensions that you want to appear in your report.
Dimensions are attributes of your data. For example, the dimension
cityindicates the city from which an event originates. The connector includes the
datedimension in all reports.
The dimensions field shows up after choosing the Google Analytics property.
For more details about the available dimensions, see API Dimensions & Metrics.
Google Analytics 4 metrics that you want to appear in your report.
Metrics are quantitative measurements of a report. For example, the metric
active1DayUsersis the number of distinct active users on your site or app within a 1 day period. You must select at least one metric.
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).
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 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.
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.