Databases and data warehouses

Google BigQuery

Serverless does not mean unknowable. Solidatus maps BigQuery datasets down to nested columns and shows exactly how each field was derived.

What it is

Structure, lineage and derivation capture from Google BigQuery, including nested column structures.

What Solidatus captures

Datasets and schemas, tables, views, columns and nested columns, data types, key constraints, view and script column-level lineage, and table and column derivation source code.

What you need

  • A BigQuery JDBC driver on the connector host, added to the Java classpath. Licensing means we cannot redistribute it, so you take it straight from the vendor and we tell you exactly where to put it.
  • A Google Cloud service account with, as a minimum, bigquery.datasets.get, bigquery.routines.get, bigquery.routines.list, bigquery.tables.get, bigquery.tables.list, resourcemanager.projects.get and bigquery.jobs.create. The jobs.create permission is what allows nested column extraction and DDL-based SQL parsing.

Good to know

Agent and Standalone mode and SOL.UIDs are supported; MultiDB models are not.

See a connector run against your estate

A demo maps one of your real sources, so you see the depth of parsing rather than a logo wall.