This extension will only work for the internal team of Fivetran Analytics. It will not work for any other users due to lack of files in your repo. Only download this if you work at Fivetran.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
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
Smart Run Commands
Smart Run (Target) - Execute a single model with intelligent dependency resolution (also supports multiple selected files)
Smart Run Full Refresh (Target) - Backfill incremental models with full refresh logic
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:
Single Model Development: Right-click on a model file → Smart Run → Smart Run
Testing Changes: Right-click on any file → Smart Run → Smart Run All Changed Models
View in BigQuery: Right-click on a model → BigQuery → View Dev Table or View Prod Table
View Dependencies: Right-click on a model → Show Dependencies → Upstream/Downstream
Requirements
Files must be SQL models (.sql extension)
Must be within the /models directory structure
Requires access to Fivetran's analytics utilities and scripts
Development
Publishing
To publish a new version of the extension:
vsce publish
Local Development
Open the extension directory in VSCode
Press F5 to launch a new Extension Development Host window
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.
