Google Search Console integration
Google Search Console data, in your warehouse.
A built-in ingestr connector: add credentials, pick tables, schedule it.
name: raw.search_analytics
type: ingestr
parameters:
source_connection: google_search_console
source_table: 'search_analytics'
destination: snowflake
incremental_strategy: merge$ bruin run assets/raw/google_search_console.asset.yml
- extract · Google Search Console search_analyticsincremental
- load · snowflake raw.search_analyticsmerged
- checks · not_null, unique
Loaded and checked. Downstream models can run.
How it connects
Connected in three steps.
Google tool for monitoring website search performance, indexing status, click-through rates, and search query analytics.
- 01
Add a Google Search Console connection with its credentials.
- 02
Pick the tables to load and how: replace, append or merge.
- 03
Bruin runs it on your schedule and checks every load.
Connection parameters
- credentials_path
- Path to Google service account JSON key
- site_url
- Verified site URL in Search Console
Tables
5 tables, ready to load.
search_analyticssitemapsurl_inspectionpagesqueries
Step-by-step
Pick a destination.
Google Search Console → Snowflake
Read the guide
Google Search Console → Google BigQuery
Read the guide
Google Search Console → Databricks
Read the guide
Google Search Console → Amazon Redshift
Read the guide
Google Search Console → PostgreSQL
Read the guide
Google Search Console → ClickHouse
Read the guide
Google Search Console → DuckDB
Read the guide
Google Search Console → MotherDuck
Read the guide
The platform
Part of the Bruin platform.
Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.
Sources
DatabasesWarehousesApps & APIsFiles & storageStreams & webhooksWeb scrapingMove
Data IngestionFrequently asked
Questions about Google Search Console.
Does Bruin have a built-in Google Search Console integration?
Yes. Built-in ingestr source.
Which Google Search Console tables can Bruin load?
search_analytics, sitemaps, url_inspection, pages, queries.
Where can Google Search Console data go?
Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.
How fresh is the data?
As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.
Do we need Bruin Cloud?
No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.
Ready to connect Google Search Console?
$100 in credits and 50 AI tasks. No credit card.
A demo walks through your own data.