Command Line Interface
Coalesce ships a command line interface, coa, for automated deploys, refreshes, and CI/CD. The CLI docs are split by major version because behavior and setup differ in important ways.
Coalesce CLI (COA 7.33 and Above)
Use this section when you run coa 7.33 or newer on Snowflake. These docs describe local development (work from your version control checkout, connect to the warehouse, iterate without routing SQL through Coalesce cloud) and cloud operations (plan, deploy, and refresh through Coalesce using access tokens and Environment IDs).
With the newer CLI, you can author and run SQL locally: edit Node SQL, preview generated DDL, create tables, run DML, and validate results in your own SQL client while you build. When the pipeline is ready, you promote it through the same coa commands for cloud-backed deploy and refresh. Start with Command Line Interface for install, authentication, and configuration, then follow the task docs below.
- Command Line Interface - Install, auth,
workspaces.yml, and~/.coa/config - Build Pipelines With the Coalesce CLI - Local build loop and pipeline authoring
- Deploy Pipelines to the Coalesce App Using COA - Cloud deploy workflow
- CLI Commands - Full command reference
- Troubleshoot the Coalesce CLI - Common errors and fixes
- CLI Support Policy & Usage Recommendations - Support scope and usage guidance
Coalesce CLI (COA 7.32 and Below)
Use this section when you're still on coa 7.32 or older. The model emphasizes connecting through the earlier configuration paths documented for that release. If you are unsure which path you use, check coa --version and talk to your admin about upgrade timing.
- Legacy CLI overview - How the earlier CLI fits CI/CD and on-prem workflows
- CLI setup (7.32 and below) - Install, profiles, tokens, and Snowflake auth
- CLI commands (7.32 and below) - Command reference for older releases
- CLI support policy (7.32 and below) - Support and usage notes for legacy versions
What's Next?
- Read Command Line Interface if you're on 7.33 or newer and need end-to-end setup
- Open CLI setup (7.32 and below) if you must stay on 7.32 or below for now
- See Deploy Using the CLI for how the CLI fits deploy and refresh in the product