Skip to main content

Visual Studio Code Extensions

Feature release status badge: PriPrev
PriPrev

Python

Extension name: ms-python.python

The core Python extension. It is a dependency for other modules but also allows running Python code with a single button click.

Better toml

Extension name: bungcip.better-toml

It provides better rendering for TOML files.

JINJA

Extension name: samuelcolvin.jinjahtml

The JINJA template rendering extension specifically within dbt models.

dbt Power User

Extension name: vscode-dbt-power-user

Main extension for dbt development and testing. Use it from the provided buttons in the top right of a SQL development window:

and:

Or by opening the plugin itself:

The automatically executed script /dataops-cde/scripts/dataops_cde_init.sh dynamically populates the required ~/.dbt/profiles.yml file.

Snowflake driver for sqltools

Extension name: koszti.snowflake-driver-for-sqltools

This extension also installs sqltools itself. The automatically executed script /dataops-cde/scripts/dataops_cde_init.sh automatically creates two Snowflake profiles using the same credentials as used for MATE/dbt, one for the production database, the second for the database that is related to the current branch:


note

The User configured needs to have a default ROLE set for this Extension to operate correctly.

Installing custom extensions

If you wish to include your custom extensions, you can do it in the .gitpod.yml file:

tasks:
- name: Setup
before: |
/dataops-cde/scripts/dataops_cde_setup.sh

image: dataopslive/dataops-gitpod-workspace:5-latest

vscode:
extensions:
- streetsidesoftware.code-spell-checker