Visual Studio Code Extensions in DDE

PriPrev

Python

Extension name: ms-python.python

The core Python extension. It is a dependency for other modules and 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 in DDE DevReady, you can do it in the .gitpod.yml file:

.gitpod.yml

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

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

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

If you wish to include your custom extensions in DDE Local or Remote, you can do it in the devcontainer.json file:

devcontainer.json

{
  "name": "DataOps Development Environment",
  "image": "dataopslive/dataops-development-workspace:5-stable",
  "runArgs": [
    "--env-file",
    ".devcontainer/devcontainer.env",
    "--tmpfs",
    "/ephemeral_creds"
  ],
  "containerEnv": {
    "DATAOPS_FEATURE_MATE_DBT_VERSION": "1.4"
  },
  "customizations": {
    "vscode": {
      "extensions": [
        "ms-python.python",
        "koszti.snowflake-driver-for-sqltools",
        "samuelcolvin.jinjahtml",
        "bungcip.better-toml",
        "snowflake.snowflake-vsc",
        "/dataops-dde/extensions/vscode-dbt-power-user-0.13.0.vsix",
        "/dataops-dde/extensions/dataops-live-0.0.3.vsix",
        "GitLab.gitlab-workflow"
      ]
    }
  }
}