Coalesce supports searching for Nodes through the Graph, Node Grid, and Column Grid view, which can be helpful when searching for specific ones in a large DAG. The Node Selector is also available in the following parts of the application:

  • Browser - to filter Nodes within the entire DAG
  • Subgraphs - to filter Nodes within the Subgraph
  • Jobs - to define a set of nodes to be Refreshed
  • API and CLI - to Refresh ad hoc Nodes
Location of Search filter

Location of Selector filter in Browser

Search Syntax

Below you'll find a table with the available attributes and their effects, along with a screenshot of an example DAG with which you can try the provided usage examples. These will work for both Include and Exclude searches.

You can also use multiple attributes together, such as:

{name: *SUPPLIER* location: BI nodeType: Dimension }
AttributeDescriptionExample
nameSelects a set of nodes matching the specified name{name:STG_SUPPLIER}
nodeIDSelects a node with the specified nodeID{nodeID:98}
locationSelects a set of nodes matching the specified storage location{location:STAGING}
nodeTypeSelects a set of nodes matching the specified node type{nodeType:"DIMENSION"}
subgraphSelects a set of nodes that exist in the specified subgraph{subgraph:"MY DIMENSIONS"}

Below you'll find a table with the available operators and their effects.

OperatorEffectExample Usage
ORSelects results for either term, like an OR statement.{name:STG_*} OR {name:*REGION}
ANDSelects results for both terms, like an AND statement.{location:STAGING} AND {STG_REGION}
+Select predecessors or successors to a node, depending on placement at beginning or end.+{name:STG_SUPPLIER} selects predecessors
{name:STG_SUPPLIER}+ selects successors
*Wildcard character, represents a multiple (zero or more) characters, including space.{name:STG*}
?Wildcard character, represents a single (exactly one) characters, including space{name:STG?}
""Allows you to search for key words that have spaces{nodeType:"My Custom UDN"}