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.

DAG or Graph View​

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.

Accessibility description: Screenshot of the Coalesce DAG Exploration interface showing a large node graph. The left panel lists data nodes and aggregates. The center area displays a complex graph of interconnected nodes with a minimap in the bottom right. Below the graph, a data table lists campaign deals with columns for deal key, name, and date range. The bottom status bar shows user information and Snowflake account details.
Show the DAG or Graph View.
  1. Include and exclude - Click and drag Nodes into the filters to either include or exclude Nodes from the Graph view.
  2. 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 or view Column Lineage. Right-click on a column to view all available options.
  3. Node View Options
    1. All - View all Nodes
    2. Upstream - Shows all Nodes that feed into the selected Node.
    3. Downstream - Shows all Nodes that depend on the selected Node.
    4. Related - Shows both upstream and downstream Nodes for the selected Node.
    5. Spotlight - Shows both upstream and downstream Nodes up to four levels deep.
  4. Mini Map - The mini map shows a view of the entire graph and highlights your current view port so you can jump quickly to any area.
    1. The mini map reflects filters so what you see always matches your current Graph view.
    2. Colors in the mini map match Node type colors in the Graph View for quick orientation.
    3. Drag the DAG to see the mini map view port change.
  5. 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.
  6. 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 including column lineage.
  2. Include and Exclude - The filter that enables Selector syntax to be used. Drag and drop Nodes into the view or type in selector syntax.
  3. View as - Change the way you view the Node Graph.
    1. Graph
    2. Node Grid
    3. Column Grid
  4. Close - Close all tabs.
  5. Selector - A tooltip showing available search syntax.
  6. Run All nodes. You can also:
    1. Validate all Nodes.
    2. Create all Nodes.
    3. Validate create all Nodes.
  7. Node Graph Controls:
    1. Change the Node view options.
    2. Toggle the mini map
    3. Reload or refresh the Graph positions.
    4. Zoom out
    5. Zoom in
    6. Reset the zoom level to the default.