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 - Execute a single model with intelligent dependency resolution (also supports multiple selected files)
Smart Run All Changed Models - Automatically detect and run all modified SQL models in your git working directory
Smart Incremental Only Run - Run incremental models with incremental logic only
Smart Incremental Backfill Run - Backfill incremental models with full refresh logic
SQL Analysis & Visualization
Render Model SQL - Preview the compiled SQL for a model
Table Diff - Compare table schemas and data between environments using SQLMesh
DAG Generator - Generate interactive dependency graphs for your models
Upstream DAG - Show all models that feed into the current model
Downstream DAG - Show all models that depend on the current model
Intersection DAG - 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
Schema Analysis: Right-click on a model → Table Diff
Dependency Visualization: Right-click on a model → DAG Generator → Upstream/Downstream DAG
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 --pre-release
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.
