Setup Requirements

List of required items to use Coalesce in your organization

Network

Warehouse whitelisting

When using Coalesce SaaS, we will connect to your data warehouse from the following IP addresses. Be sure to allow traffic from these IPs in your firewall and network policy.

35.184.36.82
34.89.191.247

🚧

Whitelist workaround

The Coalesce Command-Line Interface may be used to deploy and run jobs in a deployed environment. This omits the requirement to whitelist Coalesce IP addresses. However, the above IPs are still used during design time (using the GUI build interface) to connect with the warehouse.

Allow traffic to Coalesce services

Allow Outbound HTTPS connectivity on your network to the following domains in order to connect to Coalesce GUI, API, and/or CLI. This step is only required if your organization limits traffic to the public internet.

https://firestore.googleapis.com
https://firebasestorage.googleapis.com/
https://app.coalescesoftware.io
https://app.eu.coalescesoftware.io/
https://*.app.coalescesoftware.io
https://*.app.eu.coalescesoftware.io/
https://app.coalesce.io #future-use

git Providers

Coalesce will connect to git repositories from most git providers including GitHub, Bitbucket, Azure DevOps, and GitLab. Please view our page on Git Settings for more details.

Authentication

Authenticating to Coalesce with Single Sign-On

Optionally, Coalesce can authenticate users to the platform using Single Sign-On from Okta or Azure Active Directory identity providers. Please view our page on Single Sign-On for more details. Alternatively, password-based authentication to Coalesce is supported.

Coalesce Authenticating to the warehouse with OAuth

Optionally, Coalesce authenticates users with the warehouse using (Snowflake) OAuth. Note that ACCOUNTADMIN role is required to set up this security integration, which is a highly elevated role in Snowflake. Please view our page on OAuth Connections for more details. Alternatively, password-based authentication to the warehouse is supported.

Other

Triggering a refresh job (DML)

Jobs are triggered by one of the following methods:

  • Command Line Interface This requires our NPM package to be installed as well as package dependencies such as NodeJS. Details here: CLI Setup
  • REST API Details here: Start Job API

Deploying an environment (DDL)

Environments are deployed by one of the following methods:

  • Command-Line Interface This requires our NPM package to be installed as well as package dependencies such as NodeJS. Details here: CLI Setup
  • GUI via Deploy Wizard