Fivetran Analytics VSCode Extension

A VSCode extension designed specifically for the Fivetran Analytics team to streamline model development and testing workflows.

Note: This extension will only work for the internal team of Fivetran Analytics. It will not work for any other users due to dependencies on specific files and directory structures in the Fivetran analytics repository.

Features

Run Commands

Execute dbt run commands directly from the context menu (supports single or multiple selected files):

• -s git:main+,+model --favor-state - Run models modified since main, including their parents and children: dbt run -s 'git:main+,+model' --favor-state
• |______ do not copy incremental - Same as above but skips copying incremental models in dev: DBT_RUN_CACHE_CLONE_INCREMENTAL_IN_DEV=NEVER dbt run -s 'git:main+,+model' --favor-state
• -s model - Run specific model(s): dbt run -s model
• -s model --favor-state - Run specific model(s), skipping already-up-to-date models: dbt run -s model --favor-state
• -s +model - Run model(s) and all upstream parents: dbt run -s +model

SQL Analysis & Visualization

• Compile Model SQL - Preview the compiled SQL for a model
• BigQuery - Open models directly in the BigQuery console (automatically detects the correct BigQuery project)
  • View Prod Table - Opens the production version of the model
  • View Dev Table - Opens the dev version of the model using your dbt profile configuration and current git branch
• Show Dependencies - List model dependencies using dbt
  • Upstream - Show all models that feed into the current model
  • Downstream - Show all models that depend on the current model
  • Intersection - Show the relationship paths between two specific models

Usage

Getting Started

The extension adds context menu options when you right-click on SQL files in either the editor or Explorer panel.

Most common workflows:

1. Run a model: Right-click on a model file → dbt run → choose the desired run type
2. Run multiple models: Select multiple .sql files in the Explorer, right-click → dbt run
3. View in BigQuery: Right-click on a model → BigQuery → View Dev Table or View Prod Table
4. View Dependencies: Right-click on a model → Show Dependencies → Upstream/Downstream

Requirements

• Files must be SQL models (.sql extension)
• dbt must be available in your terminal environment

Development

Publishing

To publish a new version of the extension:

vsce publish

Local Development

1. Open the extension directory in VSCode
2. Press F5 to launch a new Extension Development Host window
3. Test your changes in the new window

Support

This extension is maintained by the Fivetran Analytics team. For issues or feature requests, please contact the team directly.