Skip to main content

The Build Interface

The Build Interface is where you'll spend most of your time creating nodes, building graphs, and transforming your data.

The Coalesce build interface

Build Interface Sidebar

The Build Interface sidebar
  1. Workspace name - The name of the workspace you're working in.
    1. Search bar - Search the node name.
    2. Click the plus sign to Add Sources(data) or Create a New Node(add an existing node type to the DAG).
  2. Categories - Change the category to:
    1. Nodes, the default
    2. Subgraphs
    3. Jobs
  3. Other Options
    1. The Problem Scanner - List problems with the current workspace.
    2. Git - Shows working branch, commits, and code differences.
    3. Build Settings - Opens a tab with the Build Settings.

Browser

The Build Interface browser
  1. Tabs - Any nodes you have open and the Node Browser will be visible here.
  2. Search - The filter that enables Selector syntax to be used.
  3. View as - Change the way you view the Node Graph.
    1. Graph
    2. Node Grid
    3. Column Grid
  4. Zoom in and out on the Node Graph.
  5. Run All nodes. You can also:
    1. Validate all nodes
    2. Create all nodes
    3. Validate create all nodes

DAG(Node Graph)

A graph represents a SQL pipeline. Each node is a logical representation and can be materialized as a table or a view in the database. Currently, you can add the following out-of-the-box types of nodes: Source, Stage, Persistent Stage, Dimension, and Fact. You can also create their own Node Types.

Node Graph or DAG
  1. Node Graph - See all the nodes you are working on.
    1. You can also see Subgraphs from here.
  2. Results and Data Pane - This section provides the user with feedback as to exactly what SQL was queried and the ability to preview the data results within the application.
  3. Other Options - See the status of your run. Validated, Created or Data Loaded.