Bruin

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.

Keyboard Shortcuts for Autocomplete

• Manual Trigger:
  • Windows/Linux: Ctrl+Space
  • Mac: Option+Esc (⌥+Esc)
• Auto Trigger: Completions appear automatically when typing : or - followed by a space

💡 Tip: If manual completion doesn't work with the default shortcuts, check your VS Code keyboard shortcuts by going to File > Preferences > Keyboard Shortcuts (or Code > Preferences > Keyboard Shortcuts on Mac) and search for "trigger suggest".

Installation

1. Open Visual Studio Code.
2. Navigate to the Extensions view (Ctrl+Shift+X).
3. 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.67.4: Fixed lineage display for pipeline.yml files and resolved issues with the lineage view not refreshing after updates.
• 0.67.3: Fixed the query preview panel environment display issue.
• 0.67.2: Improved connection test ui.
• 0.67.1: Allow YAML assets to be rendered.
• 0.67.0: Added a "Create in-place" checkbox to the project creation UI, allowing projects to be created directly in the selected folder.
• 0.66.0: Added console logging for executed query commands to aid in error detection.
• 0.65.2: Fixed table details panel bug and bruin.yaml bug.
• 0.65.1: Add full refresh to render panel.
• 0.65.0: Introduced a tags management interface that allows users to toggle the inclusion or exclusion of assets for execution in run commands.
• 0.64.7: Fixed the SQL preview rendering issue.
• 0.64.6: Updated the environment list command to create bruin.yml if it does not already exist.
• 0.64.5: Improved the .bruin.yml file handling to only show settings tab and fixed the convert message flickering issue.
• 0.64.4: Fixed the checkbox and dates state persisting issue.
• 0.64.3: Added cancel button to the table diff panel and improved the UI.
• 0.64.2: Fixed shwoing settings tab when no active editor and improved the UI.
• 0.64.1: Add secrets UI to the details tab.
• 0.64.0: Added data diff panel to the extension.

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.