Master the language of Coalesce with our curated list of essential terms, with their definitions, that you'll encounter while building your data pipelines with Coalesce. Further details about each item are available by clicking the item name.
| Build interface: | The area within the browser-based Coalesce app where the transformational data pipeline(s) is built by creating and joining nodes, applying transformations, and organizing via Subgraphs and Jobs. |
| Project: | An organizational parent object that groups your builds, deploys, and refreshes into independent areas; projects are typically organized by work purpose, team goal, and/or business area. |
| Workspace: | An independent, dedicated sandbox-style development area in which the build of the data pipeline(s) is completed, refined, and preliminarily validated before it is subsequently promoted to a higher environment. |
| Environment: | A non-sandbox higher environment (e.g. QA, UAT, PROD) where data pipelines are deployed and refreshed. |
| Storage Location: |
A logical destination for the objects you use as sources for and/or create within Coalesce, e.g. views and tables in the form of Nodes; each Coalesce Node is mapped to a single Storage Location, but a single Storage Location may be mapped to many Nodes. |
| Storage Mapping: | A physical destination-database and schema--in your database (Snowflake), that is defined for a Storage Location for a given Workspace or Environment. |
| Node: | A visual representations of a database object (e.g. table/view) that serves as a building block of a larger data pipeline in Coalesce. |
| Node Type: | A parent category for the Node object that encompasses a base definition as well as a create template and a run template that will drive how the SQL is generated for and how each Node of that type behaves during deployment and refresh. |
| Graph: |
Also known as a Directed Acyclic Graph (DAG); conceptual representation of your pipeline, illustrated by node relationships and dependencies; commonly shortened to “Graph.” |
| Subgraph: |
A subset of a larger DAG (Graph); usually consists of a logical grouping of related Nodes by by topic, flow, etc. to help you quickly view and evaluate a subset of your data pipeline. |
| Job: |
A subset of Nodes defined manually or by a Selector query and run in isolation of a broader pipeline; this is the object called by a refresh operation in Coalesce. |