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

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. See the status of your run. Validated, Created or Data Loaded.
  3. Filter and dropdowns - Add filters to only show the Nodes you want to see. Change the dropdown to:
    1. Graph - Shows the DAG.
    2. Node Grid - A table style list of Nodes. Use bulk Node editor from this view to change Node Type, Deploy Enabled, or Storage Location.
    3. Column Grid - A table style list of all the columns in all the Nodes. You can bulk edit columns here.
  4. Footer - The footer contains the branch the Workspace is attached to, the last commit made, the data platform name, user name, user role in the data platform, user email address, and organization name.

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