DataSpell 2023.3 Help

dbt support

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.

  1. Press Ctrl+Alt+S to open the IDE settings and then select Plugins.

  2. 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.

Select dbt configuration

To add a new dbt configuration, do the following:

  1. Click Add configuration on the main toolbar and select Edit configurations.

    Run/Debug Configurations dialog opens.

    Run/Debug Configurations dialog
  2. Press Alt+Insert or click Add New Configuration.

  3. Select dbt.

    Select dbt from the list
  4. Specify configuration name, select command from the dbt command list and configure additional settings, if necessary.

    dbt configuration settings
  5. Click OK.

Last modified: 11 February 2024