Skip to main content

Coalesce Tips and Tricks

Learn how to get the best out of the Coalesce App.

Editing Code​

In any code editor in Coalesce, you have access to a number of functions. Right click in the box to bring a sub-menu that has different actions, along with the available keyboard shortcuts.

Selecting Command Palette(F1) brings up a full menu of options, along with the keyboard shortcuts.

A GIF showing how to right-click in a Coalesce code editor to bring up secondary actions like copy/paste and command palette with options similar to VS Code.

Find and Replace​

You can use CTRL+F on Windows or CMD+F Mac to search, find and replace text any location in Coalesce that has a code editor.

  • Node Configuration
  • Join Tab
  • Column Editor
  • Column Testing
  • Pre-SQL and Post-SQL
  • Git Modal (read only)
The image shows a user interface for Coalesce, featuring sections for configuring deployment options, including materialization types and strategies. It displays a central code editor with YAML-like configuration settings for advanced deployment setup.

Searching Nodes​

You can search for the name of a Node in the Build Interface sidebar.

The image displays Coalesce's user interface, featuring a hierarchical list of nodes with expandable categories and a search bar. It shows a detailed view of the DIM_REGION node, listing fields like DIM_REGION_KEY, R_NAME, and SYSTEM_VERSION along with their corresponding data types.

Drag and Drop Columns​

You can drag and drop columns in multiple ways in Coalesce.

  • Multi Source Nodes
  • Ordering columns in a Node
  • Adding columns to a Node
  • Add Nodes to Jobs
An example of using drag and drop in the Coalese build interface.

Information Bar​

At the bottom of the screen, an information bar is shown. It contains the current information about your Workspace.

From left to right:

  • Branch: The current Git branch. You can click this to open the Git modal.
  • Last committed: Date of the last commit.
  • Snowflake Account: The Snowflake account name.
  • User: The email of the Snowflake account.
  • Role: The role of the Snowflake account.
  • Email: The email of the user logged into Coalesce.
  • Org: The organization and user name logged into Coalesce.
Coalesce information bar

If you are on the Project page, it will show the Git URL and the Git account name given during setup.

Tooltips​

Throughout the app, you'll see the information icon. Hover over it to find useful information related to the section.

Example of a tooltip in Coalesce.

Close All Tabs​

Quickly close all open tabs while working by clicking on the folder.

A folder with an x near it.

Viewing Your DAG​

On the Build page, there are several options that can help you view your DAG. From left to right:

  • Draw optimized graph - This will attempt to adjust the DAG view so the connections between nodes are easier to see at first glance. It doesn't change the order of execution.
  • Zoom out and Zoom in - Zoom in and out on the DAG.
  • Full screen - Full screen attempts to fit the entire DAG within the given space.
From left to right, an open circle with an arrow, magnifying glass with a line indicating zoom out, magnifying class with a plus indicating zoom in, and finally 4 arrows arranged in a square meaning full screen.

Sort Table Data​

You can sort column data by a single column or multiple columns.

Single Column Sort​

Click a column header to sort by ascending, descending, and to remove the sort and rest the order.

Multi-Column Sort​

Multi-column sort lets you select multiple columns to first sort your data by one column and then further sort it by another.

To select multiple columns, use the keyboard shortcuts:

  • macOS: CMD+SHIFT
  • Windows: CTRL+SHIFT

As you select columns, they have will have 1, 2, 3, etc appear next to them indicating the order they were selected and will sort by.

  • Primary Sort: Begin by sorting your table based on the main column. For example, if you have a lot of sources, and you want to first group by source.
  • Secondary Sort: This is the second column you want to sort on. Using the same example, After sorting by sources, then you might sort by Storage Location.
  • Tertiary and Additional Sorting - You can continue to sort data with the selected columns. Continuing the previous example, after sorting by sources, Storage Locations, you can sort by column name to see them alphabetically.