Environments

Environments are used for deploying your data pipeline to non-development Snowflake environments. They track the state of Coalesce objects and manage efficient deployment strategies.

Deploy and refresh jobs are triggered for individual environments. Once an environment has been deployed, it can be refreshed via API/CLI.

Environment Connections

Coalesce provides multiple ways to connect to the Snowflake account for an environment. Currently, Coalesce supports the following authentication methods:

• Snowflake OAuth (recommended)
• Basic Auth using Username and Password (Browser Storage)
  • Stored locally on the user's browser at design-time
  • Passed with API request body on deploy and refresh
• Basic Auth using Username and Password (Cloud)
  • Stored remotely in Coalesce's cloud secrets vault at design-time
  • Passed with API request body on deploy and refresh

📘

Authentication in the coa CLI

The CLI will always store basic authentication credentials locally