One Diagram for Every BigQuery Project and Dataset

DbSchema gives Google BigQuery teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Google BigQuery Features Download Google BigQuery JDBC Driver · All drivers

Visualizing BigQuery Projects and Datasets

Google BigQuery stores petabytes of analytical data organized into projects, datasets, and tables — a structure that can span dozens of datasets across multiple GCP projects. DbSchema connects to BigQuery via JDBC and renders the dataset-table relationship as an interactive ER diagram, giving your team a single navigable view of the entire data model. This is especially valuable for data teams onboarding new members or auditing schema coverage across business domains.

Download DbSchema Free See Google BigQuery Features

Run Interactive Queries on BigQuery Data

DbSchema's visual query builder translates table joins and filter conditions into BigQuery SQL without requiring analysts to write it by hand. Queries execute against BigQuery's serverless engine and results appear in the integrated data grid, so a team member who does not write SQL day to day can still get an answer from a multi-table join.

Explore Dataset Contents Interactively

The data explorer component lets you browse rows in any BigQuery table, apply column-level filters, and page through results — without opening the BigQuery console. This is practical for verifying data quality after ingestion jobs or spot-checking transformation outputs from dbt or Dataflow pipelines, especially when a dataset spans several tables and a console-only view would mean tab-switching between each one.

Document Your BigQuery Data Model

DbSchema generates HTML schema documentation from your BigQuery metadata, embedding ER diagrams and table definitions into a shareable, offline-capable reference. Distribute it to analysts and stakeholders who need to understand the data model without direct BigQuery console access.

From Download to a BigQuery Diagram

1. Download and install DbSchema — free, with no signup required.
2. Add the Simba BigQuery JDBC driver, available from Google's official driver download page, through DbSchema's driver manager.
3. Start a new connection pointed at the JDBC URL jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443.
4. For service account authentication, set OAuthType=0 and provide the service account email in OAuthServiceAcctEmail and the private key file path in OAuthPvtKeyPath. Alternatively, Application Default Credentials work when DbSchema runs on a machine already authenticated with the gcloud CLI, removing the need to manage key files explicitly.
5. Connect — DbSchema renders the project and dataset hierarchy as an interactive ER diagram.

BigQuery Teams Gain These DbSchema Capabilities

• Navigate multi-project BigQuery environments from a single diagram canvas
• Enable non-SQL analysts to query tables using the visual query builder
• Generate schema documentation for data governance and cataloging requirements
• Inspect table data and validate ETL pipeline output without BigQuery console access
• Design schema modifications in a visual editor before executing DDL statements

Dozens of datasets spread across multiple GCP projects finally fit on one navigable diagram. Download DbSchema for free and map your BigQuery data model today.