Environments are used for deploying your data pipeline to Snowflake environments. They track the state of Coalesce objects and manage efficient deployment strategies. You can configure your Workspace for working and Environments to actually deploy your data pipelines where you want.

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

Coalesce allows you to configure both your environment and workspace. This allows you to complete your development in a workspace and then deploy to any environment you want. For example, you can deploy to your production environment or QA environment with each one having different storage locations, storage mapping, parameters, and other options.


Environment Configuration Required

You must have your Environment configured for deploy and refresh.

In this guide, you'll learn which settings are available to configure.

  1. In your Workspace, go to Build Settings > Environments. Every Coalesce workspace comes with a DEV environment.
  2. Select the Environment you want to configure.
  1. Settings - Includes general account information such as the Environment name and the Snowflake connection URL. Take note of the Environment ID. You'll use this when making API requests to see information about the deployment.
  2. User Credentials - Configure how you want to connect to Snowflake. If you want to use OAuth (recommended), you'll also need to add your OAuth Settings. Learn more about Connecting to Snowflake.
  3. Storage Mappings - To deploy or refresh your environment, you need to have your Storage Mappings setup. Storage Mappings are represent the physical locations in Snowflake. This is where your data pipeline will deploy. Learn more about Storage Mappings.
  4. Parameters - Parameters are defined as a JSON blob set by the user that can be accessed in the metadata during template rendering. Learn more about Parameters.
  5. OAuth Settings - If you're using OAuth to connect to Snowflake, you'll need to configure OAuth here.
Environment Settings

Environment Settings