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.
Command
ingestr ingestDefined 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.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.