Skip to main content

Navigate the interface beta

The visual editor interface contains an operator toolbar, operators, canvas, built-in AI, and more to help you create dbt models through a seamless drag-and-drop experience in dbt Cloud.

Beta feature

The visual editor provides users with a seamless and visual, drag-and-drop experience inside dbt Cloud. It's available in private beta for dbt Cloud Enterprise accounts.

To join the private beta, register your interest or reach out to your account team to begin this process.

This page offers comprehensive definitions and terminology of user interface elements, allowing you to navigate the dbt Cloud visual editor landscape with ease.

The visual editor interface is composed of:

  • Operator toolbar — Located at the top of the interface, the toolbar displays all the nodes available. Use the toggle on the left of the toolbar to display or hide it.
  • Operators — perform specific transformations or configurations (such as model, join, aggregate, filter, and so on). Use connectors to link the operators and build a complete data transformation pipeline.
  • Canvas — The main whiteboard space below the node toolbar. The canvas allows you to create or modify models through a sleek drag-and-drop experience.
  • Configuration panel — Each operator has a configuration panel that opens when you click on it. The configuration panel allows you to configure the operator, review the current model, preview changes to the table, view the SQL code for the node, and delete the operator.

Operators​

The operator toolbar above the canvas contains the different transformation operators available to use. Use each operator to configure or perform specific tasks, like adding filters or joining models by dragging an operator onto the canvas. You can connect operators using the connector line, which allows you to form a complete dbt model for your data transformation.

Use the operator toolbar to perform different transformation operations.Use the operator toolbar to perform different transformation operations.

Here the following operators are available:

Input​

  • Input model: Select the model and columns you want to use.

Transform​

  • Join: Define the join conditions and choose columns from both tables.
  • Select: Pick the columns you need from the model.
  • Aggregate: Specify the aggregation functions and the columns they apply to.
  • Formula: Add the formula to create a new column. Use the built-AI code generator to help generate SQL code by clicking on the question mark (?) icon. Enter your prompt and wait to see the results.
  • Filter: Set the conditions to filter data.
  • Order: Select the columns to sort by and the sort order.
  • Limit: Set the maximum number of rows you want to return.

Output model​

  • Output model: The final transformed dataset generated by a dbt model.

Currently, you can only have one output model in the visual editor, but in the future, it'll be possible to have multiple output models.

When you click on each operator, it opens a configuration panel. The configuration panel allows you to configure the operator, review the current model, preview changes to the model, view the SQL code for the node, and delete the operator.

Visual editor interface that contains a node toolbar and canvas.Visual editor interface that contains a node toolbar and canvas.

If you have any feedback on additional operators that you might need, we'd love to hear it! Please contact your dbt Labs account team and share your thoughts.

Canvas​

The visual editor has a sleek drag-and-drop canvas interface that allows you to create or modify dbt SQL models. It's like a digital whiteboard space that allows analysts to deliver trustworthy data. Use the canvas to:

  • Drag-and-drop operators to create and configure your model(s)
  • Generate SQL code using the built-in AI generator
  • Zoom in or out for better visualization
  • Version-control your dbt models
  • [Coming soon] Test and document your created models
The operator toolbar allows you to select different nodes to configure or perform specific tasks, like adding filters or joining models.The operator toolbar allows you to select different nodes to configure or perform specific tasks, like adding filters or joining models.

Connector​

Connectors allow you to connect your operators to create dbt models. Once you've added operators to the canvas:

  • Hover over the "+" sign next to the operator and click.
  • Drag your cursor between the operator's "+" start point to the other node you want to connect to. This should create a connector line.
  • As an example, to create a join, connect one operator to the "L" (Left) and the other to the "R" (Right). The endpoints are located to the left of the operator so you can easily drag the connectors to the endpoint.
Click and drag your cursor to connect operators.Click and drag your cursor to connect operators.

Configuration panel​

Each operator has a configuration side panel that opens when you click on it. The configuration panel allows you to configure the operator, review the current model, preview changes, view the SQL code for the operator, and delete the operator.

The configuration side panel has the following:

  • Configure tab — This section allows you to configure the operator to your specified requirements, such as using the built-in AI code generator to generate SQL.
  • Input tab — This section allows you to view the data for the current source table. Not available for model operators.
  • Output tab — This section allows you to preview the data for the modified source model.
  • Code — This section allows you to view the underlying SQL code for the data transformation.
A sleek drag-and-drop canvas interface that allows you to create or modify dbt SQL models.A sleek drag-and-drop canvas interface that allows you to create or modify dbt SQL models.
0
Edit this page