Visual Studio Code Extensions in DataOps.live Develop

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 DevReady, you can do it in a .gitpod.yml file you add to the project's directory:

.gitpod.yml

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

If you wish to include your custom extensions in DevPod, you can do it in the devcontainer.json file:

devcontainer.json

{
  "name": "DevPod",
  "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"
      ]
    }
  }
}