ingestr recipes/Load a specific sourceData Engineer

How do I load Google Analytics data into my warehouse?

The Google Analytics source exposes GA4 custom and realtime reports built from dimensions such as date and metrics such as activeUsers. ingestr reads them with a service account and property ID, then lands them in your warehouse using one command. Bruin does this in one platform: ingestion, SQL and Python pipelines, quality checks, lineage, and an AI data analyst that answers in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email and the browser.

Get ingestr on GitHub How ingestr works

Command

ingestr ingest

Defined in

CLI

Works with

Google Analytics to any ingestr destination

What you get

GA4 Data API sourceno connector codecustom and realtime reports

How it works in code

$ ingestr ingest \
  --source-uri 'googleanalytics://?credentials_path=/path/to/service/account.json&property_id=123456789' \
  --source-table 'custom:date:activeUsers' \
  --dest-uri $SNOWFLAKE_URI --dest-table 'ga4.active_users'

Run ingestr ingest and ingestr loads the Google Analytics data into your warehouse.