Skip to main content

dbt Cloud features

dbt Cloud IDE​

πŸ“Œ

The new and refreshed Cloud IDE is now GA. It includes performance upgrades, ergonomics improvements, and some delightful enhancements!

Review the new Cloud IDE features to learn more.

The dbt Cloud integrated development environment (IDE) allows you to build, test, run, and version control your dbt projects directly from your browser. The IDE is the fastest and most reliable way to deploy dbt, and provides a real-time editing and execution environment for your dbt project β€” no command line required. Anyone can use the IDE, from new dbt developers to seasoned practitioners.

With the Cloud IDE, you can:

  • Write modular SQL models with select statements and the ref() function
  • Compile dbt code into SQL and execute it against your database directly
  • Test every model before deploying them to production
  • Generate and view documentation of your dbt project
  • Leverage git and version-control your code from your browser with a couple of clicks
  • Create and test Python models:
    • You can compile Python models to see the full function that gets executed in your data platform
    • You can see Python models in DAG in dbt version 1.3 and higher
    • You can't preview python models, currently
  • Visualize a directed acyclic graph (DAG), and more

IDE features​

The dbt Cloud IDE comes with features, including better performance and exciting enhancements, making it easier for you to develop, build, compile, run and test data models. Check out the some of the features below to learn more:

FeatureInfo
File state indicatorsAbility to see when changes or actions have been made to the file. The indicators M, U, and β€’ appear to the right of your file or folder name and indicate the actions performed:

- Unsaved (β€’) β€” The IDE detects unsaved changes to your file/folder
- Modification (M) β€” The IDE detects a modification of existing files/folders
- Untracked (U) β€” The IDE detects changes made to new files or renamed files
Build, test, and run codeBuild, test, and run your project with a button click or by using the Cloud IDE command bar.
Drag and dropDrag and drop files located in the file explorer, and use the file breadcrumb on the top of the IDE for quick, linear navigation. Access adjacent files in the same file by right clicking on the breadcrumb file.
Organize tabsYou can:
- Move your tabs around to reorganize your work in the IDE
- Right-click on a tab to view and select a list of actions to take
- Close multiple, unsaved tabs to batch save your work
Multiple selectionsYou can make multiple selections for small and simultaneous edits. The below commands are a common way to add more cursors and allow you to insert cursors below or above with ease.

- Option-Command-Down arrow
- Option-Command-Up arrow
- Press Option and click on an area
FormattingFormat your files with a click of a button, powered by sqlfmt.
Git diff viewAbility to see what has been changed in a file before you make a pull request.
dbt autocompleteThere are four new types of autocomplete features to help you develop faster:
- Use ref to autocomplete your model names
- Use source to autocomplete your source name + table name
- Use macro to autocomplete your arguments
- Use env var to autocomplete env var
Dark modeUse dark mode in the Cloud IDE for a great viewing experience in low-light environments.
0