Visual Studio Code Extensions in DDE
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:
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:
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:
{
"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"
]
}
}
}