Skip to content
| Marketplace
Sign in
Visual Studio Code>Snippets>datavault4dbt SnippetsNew to Visual Studio Code? Get it now.
datavault4dbt Snippets

datavault4dbt Snippets

Scalefree

|
24 installs
| (4) | Free
Create Datavault4dbt code blocks with ease
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

datavault4dbt VSCode Snippets by Scalefree International GmbH

A collection of snippets for the datavault4dbt package by Scalefree. Provides scaffolding and code blocks for data vault entities as well as pre-populated hash keys and model names according to naming conventions.

Features

  • templates all datavault4dbt entities
  • supporting code blocks for repeated tasks like setting hash key and hashdiff
  • prepopulates hash keys from model name

How to Use

Datavault4dbt snippets are prefixed with two underscores. Codeblocks created by these have several prepopulated fields that you can go through by tabbing through them. When creating a Stage, you can use the __stg snippet to create the skeleton for the stage macro that you can then tab through to fill out all steps necessary to build your model. Create a new hashkey by using the __hk block, add a multi-active satellite by using __ma_config, and many more.

Snippets

Category Type Prefix
Datavault4dbt entities
Stage __stg, __stg_dv
Hub Standard __hub, __h
Link Standard __link,__l
Non-historized __nh_link, __nhl, __nl
Satellite Standard v0 __sat_v0, __v0
Standard v1 __sat_v1, __v1
Non-historized __nh_sat
Record-Tracking ___rts
Effectivity __es, __effsat,__eff_sat
Multi-Active v0 __msat_v0,__ms_v0
Multi-Active v1 __msat_v1,__ms_v1
Reference Hub __ref_hub, __rh
Satellite v0 __ref_sat_v0, __rs_v0
Satellite v1 __ref_sat_v1, __rs_v1
Table __ref_table, __r
PIT Table __PIT, __pit
Snapshot Control v0 __snap_ctrl_v0,__sc_v0
v1 __snap_ctrl_v1,__sc_v1
Supporting Snippets
Stage Hash Key __hk,__hashkey
Hash Diff __hd, __hashdiff
Prejoined Column __prejoin
Derived Column __stg_derived_column
Missing Column __stg_missing_column
Multi-active Config __ma_config, __multi_active_config
Raw Vault Source Model __src_model, __source_model
Business Vault Snapshot Control Desired Duration __log_logic,__logarithmic_logic

Enjoy!

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft