Skip to main content

Command Line Interface

Nodejs 18 End of Life

Starting with the 7.24 release, we are updating the supported Node.js versions for the coa CLI to ensure you are working in a stable and secure environment.

What's Changing?​

The coa CLI will now enforce the use of the following Node.js versions:

  • 20
  • 22
  • 24

Version 18 will no longer be supported.

Why We're Making This Change​

We're removing support for version 18 because it reaches its end-of-life in April 2025. Support for version 24, a Long-Term Support (LTS) version, has been added to ensure continued stability and security.

Action Required​

If you are running Node.js version 18, you must upgrade to a supported version to continue using the coa CLI. After updating to release 7.24, running the CLI with Node.js version 18 will cause the CLI to exit with the following error message:

Invalid node version 18 not supported

Coalesce provides a CLI (Command Line Interface, or coa) to enable automated CI/CD workflows for Coalesce projects. The CLI coa is intended for users with stringent on-premise data requirements and connects directly to Snowflake from your local environment instead of using the Coalesce cloud backend to route Snowflake SQL commands and data.

The CLI and SaaS app can be used in tandem. For example, users may prefer our SaaS app for development and switch to our CLI for production, or choose to deploy using the GUI and refresh the data warehouse via the CLI.

CLI Outbound Connection

Coalesce CLI uses an outbound connection to Coalesce metadata for tracking environment state and execution results.

How Does Coalesce CLI Work?​

  1. The user commits their Coalesce project to a Git repository using the SaaS app.
  2. The Git repository is cloned to a local machine on which coa is installed.
  3. The user executes code locally with coa commands. coa reads the files from the locally cloned Git commit and deploys the metadata configuration to an environment.
  4. The deploy saves the metadata configuration to the environment, so that future refreshes use the current state of the data warehouse stored in the metadata.

The team will run the refresh every hour, only issuing a deploy when a structural change to the data warehouse is needed.

REST API​

Coalesce also offers a rest API for some of the functionality provided by coa, the CLI tool. The rest API can be a useful option for those that do not want to maintain on-premise infrastructure, but it does connect directly to your Snowflake environment from the Coalesce Cloud backend.