Install Node.js if you haven't already. We recommend using the latest stable version (18 as of this writing).
Windows doesn't come with git installed by default, so you will need to download and install it from https://gitforwindows.org/
To install Coalesce CLI globally, run:
npm install -g @coalescesoftware/coa
To update, run:
npm upgrade -g @coalescesoftware/coa
- 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
.coaand an empty file with no extension called
configwithin it. You will be populating this file in the next section.
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
[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.
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 25 days ago