Dataform Plugin for IntelliJ brings full language support for Google Cloud Dataform projects to IntelliJ IDEA, so you can write, navigate, run and debug SQLX pipelines without leaving the IDE.

View the plugin on JetBrains Marketplace · Source code on GitHub

Why the plugin asks you to sign in with Google

The plugin uses your Google account only to work with Google Cloud on your behalf: to interact with your Dataform repositories and workspaces (browse, create, push and pull files), to run Dataform workflow actions, and to execute queries in BigQuery. Your credentials stay on your computer, in the IDE password store, and the plugin never sends your data to its developer or to any third party. See the Privacy Policy for details.

Features

SQLX language support

  • Syntax highlighting for SQLX files, covering embedded SQL, JavaScript and config blocks.
  • Code completion for Dataform functions (ref(), declare(), publish(), …), JavaScript and TypeScript symbols, and template expressions (${...}).
  • BigQuery SQL dialect support with syntax validation and error highlighting.
  • Schema-based validation and completion for workflow_settings.yaml and config { } blocks.
  • Jump between references, includes and declarations with Ctrl+Click / Ctrl+B.
  • Column-level navigation from a query to the column’s declaration in the source table.
  • Quick Documentation (Ctrl+Q) for tables, columns, config keys and BigQuery functions.
  • Template expressions folded to their evaluated value.
  • In-place column rename that follows the column through the whole pipeline.

Compilation and preview

  • Background compilation, with Dataform and BigQuery dry-run errors shown on the exact tokens.
  • Split editor next to each SQLX file with the compiled query, resolved schema and lineage graph.

Data lineage

  • Project and file lineage graphs of the dependencies between Dataform actions.
  • Column-level lineage to trace where each column’s data comes from.

Run and execute

  • Run configurations and gutter icons to run actions, tags or the whole workflow.
  • Live execution view with BigQuery job details.
  • Execute compiled queries in BigQuery, with paged results in a data grid.

Unit tests

  • Generate Dataform tests pre-filled from resolved schemas.
  • Run tests from the gutter, with results and diffs in the IDE test runner.

Google Cloud integration

  • Sign in to Google Cloud from the Dataform tool window, with no gcloud login needed.
  • Manage repositories, browse and create workspaces, push and pull files.
  • Compare a local file with its version in the remote workspace.

Formatting and project tooling

  • Built-in SQLX formatter, with optional Sqlfluff integration.
  • New Project wizard, SQLX file templates and automatic Dataform CLI setup.

Installation

  1. In IntelliJ IDEA, open Settings ▸ Plugins ▸ Marketplace.
  2. Search for Dataform and install the plugin, or use the button above.
  3. Restart the IDE.

Requirements: IntelliJ IDEA 2026.1 or later and Node.js.

Support

Report bugs and request features on the GitHub issue tracker.

Privacy Policy · Terms of Service

Dataform Plugin for IntelliJ is an independent open-source project, not affiliated with or endorsed by Google or JetBrains.