Bruin is a unified analytics platform that enables data professionals to work end-to-end for their data pipelines. This extension is built to improve the development experience of data products on Bruin using Visual Studio Code.
🚀 Key Features
Assets Details viewer
Show and update asset details from the UI.
Renders SQL content within a VS Code Webview.
Copy SQL content with a single click.
Auto-refreshes when the file is updated.
Supports running and validating assets with options like --downstream and --full-refresh via checkboxes.
Date inputs for selecting start and end dates for the run command.
Connections Management
Display and manage connections integrated with Bruin CLI.
Add, remove or duplicate connections directly from the UI.
Test exsiting connections to ensure their validity.
Bruin Settings
The Settings tab in the side panel provides a straightforward way to install and update the Bruin CLI.
Access Bruin documentation or view system information with a single click.
Asset Lineage
View and interact with the lineage of assets.
Expand each node to see dependencies and easily access asset files.
Toggle visibility for upstream and downstream assets.
Query Preview Panel
Visualizes query execution results in a new panel.
Displays formatted output for easier analysis.
Supports multi-tab functionality to run different queries separately.
Autocomplete and Snippets
Autocomplete support for .bruin.yml, pipeline.yml, and *.asset.yml files with predefined options and schema validations.
Snippets for creating Bruin root configuration, pipelines, and assets.
Installation
Open Visual Studio Code.
Navigate to the Extensions view (Ctrl+Shift+X).
Search for "Bruin" and click Install.
Note: Ensure that you have the Bruin CLI installed on your system before using the new features. For guidance on installing the Bruin CLI, please refer to the official documentation.
Release Notes
Recent Update
0.57.0: Added Ingest Asset UI with dropdowns for selecting source and destination connections.
0.56.1: Added missing LIMIT to query execution.
0.56.0: Grouped databases by environment to avoid confusion with duplicates.
0.55.2: Fixed asset node Click navigation & long name expansion in Lineage view.
0.55.1: Added support for dependency mode and SCD2 strategy.
0.55.0: Added support for highlighting the asset path in the lineage view.
0.54.4: Added support for additional seed asset types in snippets, schema and UI.
0.54.3: Conditionally show the Fill from Query button based on whether the active file is a SQL file.
0.54.2: Fixed the Query Preview Panel recreation on database load to prevent previous query output loss.
0.54.1: Fixed the Bruin Panel rendering issue.
0.54.0: Added human-readable cron preview via CodeLens in pipeline YAML files.
0.53.2: Relocated fill from DB buttons to the asset columns and materialization tabs and improved query output rendering.
0.53.1: Added default Exclude Tag input to the extension settings to exclude assets with specific tags from being validated.
0.53.0: Added pipeline asset and dependency management, including collapsible sections, improved layout, and support for external dependencies.
0.52.0: Added an Activity Bar to browse databases, view table details, and preview queries.
0.51.7: Added support and validation for the private_key_path field in Snowflake connections.
0.51.6: Added support for fill asset dependencies and columns from DB.
0.51.5: Added confirmation prompt before running with full-refresh.
0.51.4: Fixed customCheck not showing on first render, added missing sensor types to the YAML schema, and expanded snippet completions.
0.51.3: Enhanced Snowflake connection support with private key authentication, including validation and improved input handling.
0.51.2: Enabled auto-saving for materialization changes, removing the manual save button.
0.51.1: Fixed BQ connection updates and improved service account credential handling.
0.51.0: Added inline "Preview" button using CodeLens for top-level queries in the editor.
For a full changelog, see Bruin Extension Changelog.
How to Update
To update to the latest version, search for "Bruin" in the Extensions Marketplace and click the Update button.
