Installation Prerequisites

Install Node.js. We require node.js version 14.15.3, which you can specify using a version manager, such as nvm.

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.

In your operating system's home directory, create a hidden folder .coa and an empty file with no extension called config 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 Oauth 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 Oauth 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:

GitHub
GitLab
BitBucket
Azure DevOps