CLI Setup
Installation Prerequisites
Install Node.js version 18.x if you haven't already.
Windows Users
Windows doesn't come with git installed by default, so you will need to download and install it from https://gitforwindows.org/
Installation
To install Coalesce CLI globally, run:
npm install -g @coalescesoftware/coa
To update, run:
npm upgrade -g @coalescesoftware/coa
Generating Your Token
- Sign into Coalesce.
- Click on the 'Deploy' tab at the top.
- Hover over 'Generate Access Token' and copy the token that appears.

Generating an Access Token
- In your operating system's home directory, create a hidden folder
.coa
and an empty file with no extension calledconfig
within it. You will be populating this file in the next section.
Setting up Your Configuration File
Using the file you previously generated, populate it with the relevant information from your Snowflake account in the following format:
[default]
token=yourtoken
snowflakeAccount=your Snowflake account, example ww123.us-central1.gcp
snowflakeAuthType=Basic or KeyPair
snowflakePassword=password
snowflakeRole=SYSADMIN (or other role)
snowflakeUsername=username
snowflakeWarehouse=COMPUTE_WH
environmentID=one of your non-dev environments
[testing]
token=yourtoken
snowflakeAccount=your Snowflake account, example ww345.us-central1.gcp
snowflakeAuthType=Basic or KeyPair
snowflakePassword=password
snowflakeRole=SYSADMIN (or other role)
snowflakeUsername=username
snowflakeWarehouse=COMPUTE_WH
environmentID=one of your non-dev environments
Note the [default]
will be the default Snowflake profile used, though others can be added below in the same format and loaded instead. See [testing]
example above.
Cloning Your Repository
Make sure to clone the repository connected to your Coalesce account into your home directory. There are many potential ways to do this, so check your git provider's documentation for needed steps. Links below are included for your convenience:
Updated 4 months ago