What is the "Snowflake Native" Google Analytics 4 ?

A Google Analytics 4 dashboard built exclusively using Snowflake Native Apps. Chat with Arctic about your website or mobile app.

Comment 1

Inspiration

We developed a Snowflake Native App to leverage Google Analytics 4 (GA4) data and deepen customer understanding. Snowflake Native Apps is an excellent solution that treats data processing logic as a first-class asset. With this product, we realized a future where prebuilt data processing assets can be introduced into a company with just a single click.

What it does

We had previously implemented a graph display function in the GA4 dashboard created with Snowflake Native Apps, but this time we added a large language model (LLM). The purpose of creating this application is to enable employees, even those without SQL knowledge, to deepen their understanding of customers through GA4 data.

How we built it

For this application, I used only Snowflake Native Apps such as Streamlit in Snowflake, Snowflake Connector for Google Analytics Raw Data Connector, and Snowflake Cortex LLM Completion (Arctic).

Challenges we ran into

  1. To call Snowflake Arctic from within Native Apps, IMPORTED PRIVILEGES needs to be executed.
  2. It is not possible to call models created with Cortex Forecast ML Forecast from within Native Apps.

Accomplishments that we're proud of

I fully utilized Snowflake Native Apps to create a future Google Analytics dashboard. This dashboard can be downloaded from the store with a single click, and everything runs on Snowflake, so there is no risk of data leakage. It will also be available on the Snowflake Marketplace soon.

What we learned

  1. By adding IMPORTED PRIVILEGES to manifest.yml and executing queries in the worksheet, Snowflake Arctic can be called from within Native Apps.
  2. Currently, tables for storing ML Forecast prediction results are created manually, so Native Apps using Cortex Forecast cannot be released on the Snowflake Marketplace.

What's next for GoogleAnalytics4 Dashboard for LLM

We want to analyze the differences in behavior for each emotion using product DB survey data and Cortex LLM Sentiment.

Built With

  • snowflake-connector-for-googleanalytics
  • snowflake-cortex-llm
  • snowflake-cortex-ml
  • snowflake-native-apps
  • streamlit-in-snowflake
Share this project:

Updates