Skip to main content
Focus: Build data pipelines, models, and applications using our integrated VS Code-based IDE with pre-configured tools for dbt, Python, and Streamlit development. The 5X IDE delivers a native VS Code experience directly within your browser, seamlessly integrating with your data warehouse and the broader 5X ecosystem. Build reliable data models, create custom Python applications, and develop interactive dashboards all in one powerful development environment.

​
What is the 5X IDE?

The 5X IDE is a comprehensive development environment designed specifically for data professionals. It combines the power of VS Code with specialized tools for data development, providing everything you need to build, test, and deploy data applications.

​
Core capabilities

VS Code integration

Familiar development experienceFull VS Code functionality with extensions, themes, and customization options

Data warehouse access

Direct data connectivityQuery and explore your data warehouse with integrated database explorer

dbt development

Data transformationBuild and test dbt models with lineage visualization and testing tools

Python applications

Custom developmentCreate Python scripts, data pipelines, and machine learning applications

Streamlit dashboards

Interactive applicationsBuild and deploy interactive data dashboards and applications

Metrics Store

Centralized data governanceDefine and transform data with Metrics models

Git integration

Version controlFull Git workflow with visual interface and collaboration tools

​
IDE features overview

​
Pre-configured development stack

The IDE comes ready-to-use with all the tools data professionals need: Python environments:
  • Multiple Python versions (3.9.23, 3.10.18, 3.11.13, 3.12.11, 3.13.4)
  • Virtual environment management
  • Package management with pip
  • Interactive Python shell
dbt development:
  • Pre-installed dbt Power User extension
  • Multiple dbt versions (1.6.18, 1.7.19, 1.8.9, 1.9.10)
  • Lineage visualization
  • Model execution and testing
Data warehouse support:
  • BigQuery, Snowflake, Redshift, PostgreSQL
  • Secure credential management
  • Real-time data access
  • Query execution and export
Development tools:
  • Git integration with visual interface
  • Terminal access with custom shortcuts
  • Extension marketplace
  • Customizable workspace

​
Getting started

​
Quick start workflow

1

Set up credentials

Configure your data warehouse credentials in Settings → IDE → Credentials
2

Create repository

Set up a new repository in Settings → IDE → Repositories
3

Start IDE session

Navigate to IDE tab and click “Start Session”
4

Begin development

Access your repositories and start building data applications
Tip: Verify that you’ve selected a supported compute profile.

​
Supported use cases

The IDE is optimized for these common data development tasks: Data modeling and transformation:
  • Build dbt models with version control
  • Test data transformations
  • Generate documentation
  • Visualize data lineage
Python data applications:
  • Create data processing scripts
  • Build machine learning pipelines
  • Develop API integrations
  • Process and analyze data
Interactive dashboards:
  • Build Streamlit applications
  • Create data visualizations
  • Deploy interactive reports
  • Share insights with stakeholders

​
Getting started

Ready to start developing? Follow these quick start guides:

IDE Setup

Configure your environmentSet up data warehouse credentials and repositories to start developing.

Development Workflows

Start buildingLearn how to create dbt models, Python applications, and Streamlit dashboards.

Migrating to new VS code based IDE

Switch from legacy IDEStep-by-step guide to move to the new VS Code–based IDE.