DataSpell supports dbt® Core — an open-source data modeling tool, that allows users to transform, test, and deploy data in their data warehouses using SQL.
Enable the Database Tools and SQL plugin
This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in DataSpell by default. If the relevant features aren't available, make sure that you didn't disable the plugin.
Press Ctrl+Alt+S to open the IDE settings and then select.
Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name.
dbt support in DataSpell includes:
Effortless project creation: you can easily create your dbt® project using a predefined template.
Easy Run, Build, and Debug: execute, build, or debug your project with Run Configurations in just a few clicks.
Intelligent code completion: DataSpell offers smart code completion for SQL and YML files.
Get familiar with the user interface
Use Run configurations
To run a dbt command, select the configuration from the list of dbt configurations on the main toolbar and click Run.
To add a new dbt configuration, do the following:
Click Add configuration on the main toolbar and select Edit configurations.
Press Alt+Insert or click Add New Configuration.
Specify configuration name, select command from the dbt command list and configure additional settings, if necessary.