Skip to main content

Visual Studio Code Extensions in DataOps.live Develop

Feature release status badge: PubPrev
PubPrev

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"
]
}
}
}