Skip to content

Releases: Workday/vscode-dbt-json

v1.1.0

26 Mar 12:56
59bd00a

Choose a tag to compare

What's Changed

  • Added an optional case_sensitive field at the model and field levels for explicit overrides; global default is managed via Lightdash config
  • Fixed: Filter out inherited Lightdash metrics that reference unavailable columns during YAML generation

Full Changelog: v1.0.1...v1.1.0

v1.0.1

26 Mar 10:47
6f4fc14

Choose a tag to compare

What's Changed

  • v1.0.1 - Added a confirmation dialog when creating a model to resume a saved draft or start fresh

Full Changelog: v1.0.0...v1.0.1

v1.0.0

26 Mar 09:43
56d42a5

Choose a tag to compare

What's Changed

This release introduces a major update to the DJ (dbt-json) Framework with new features, architectural improvements, enhanced code quality, and comprehensive documentation.

New Features

  • Visual Data Modeling - Node-based UI editor for building dbt models visually.
  • Lineage - Column-level lineage visualization and Data Explorer enhancements.
  • dbt Command Execution - Run dbt commands natively from VS Code.
  • Lightdash Integration - Preview Manager with one-click BI dashboard previews.
  • dbt Test Execution - Run dbt test through UI.
  • Tutorials & Assist Me - Guided tutorials and contextual help features.

Architecture & Code Quality

  • Service Modularization - Decomposed monolithic services into focused modules:
    • Framework Service split into specialized handlers (lineage, models, preferences, UI).
    • Sync Engine reconstructed into 12 specialized modules.
  • Import Management - Implemented auto-sorting for imports.
  • Build Updates - Replaced ts-node with tsx to fix vulnerabilities and move off unmaintained package.

Enhancements

  • Improved extension load time by replacing sequential file I/O with parallel operations for 90 schema files.
  • Centralized Python-dependent shell command execution with consistent virtual environment handling.

Documentation

  • Reorganized documentation into logical directories:
    • Setup guides in docs/setup/ (4 files + README)
    • Integration guides in docs/integrations/ (4 comprehensive guides)
    • Updated all 11 model type documentation files
  • Added documentation for Visual Editor, Lineage, and Settings Configuration.
  • Added 10 demo videos across documentation.
  • Added AGENTS.md (Open Spec) for AI coding agent context (Cursor, Copilot, etc.).

Developer & User Experience

  • Real-time VS Code settings validation with contextual error messages.
  • .gitignore prompt to add .dj folder on first launch.
  • Guard extension initialization to only run when dbt projects exist.

Full Changelog: v0.1.0...v1.0.0

0.1.0

31 Oct 06:46
aa25e43

Choose a tag to compare

Initial Release

We are excited to announce the open-source release of vscode-dbt-json, a VS Code extension that transforms dbt development through a structured, JSON-first approach powered by JSON Schema. This extension streamlines the process of editing dbt configuration files by providing intelligent language features that significantly enhance developer productivity.

The Solution: JSON Schema-Powered Development

At its core, vscode-dbt-json leverages the JSON Schema standard to provide robust validation and intelligent editing capabilities. The extension maintains comprehensive JSON Schema definitions that accurately describe the structure, permissible values, and required fields for dbt configurations. Through the Language Server Protocol, these schemas enable powerful real-time features that make dbt development faster and more reliable.

Key Features

Core Functionality

  • JSON-First Development: Define dbt models and sources as .model.json and .source.json files with full JSON Schema validation
  • Auto-Generation: Automatically generates dbt SQL and YAML files from JSON configurations
  • IntelliSense & Autocompletion: Smart autocomplete for models, sources, columns, and SQL expressions as you type, suggesting valid property names and permissible values
  • Real-time Validation: Instant error detection with JSON Schema validation, flagging incorrect syntax, missing required fields, or properties used in wrong contexts

Model Development

  • 11 Model Types: Complete coverage from staging to marts
    • Staging: stg_select_source, stg_union_sources, stg_select_model
    • Intermediate: int_select_model, int_join_models, int_join_column, int_union_models, int_lookback_model, int_rollup_model
    • Mart: mart_select_model, mart_join_models
  • Modern Web Interface: React-based UI for scaffolding model and source JSONs

Integrations

  • Trino Integration: Browse data catalogs and execute queries directly in VS Code
  • Lightdash Support: Built-in BI integration for creating dashboards from dbt models
  • Airflow DAG Generation: Automatic generation of Airflow DAGs for orchestration

Get Started: Installation Guide | Tutorial
Support: GitHub Issues | Discussions

Full Changelog: https://github.com/Workday/vscode-dbt-json/commits/v0.1.0