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
Updated 2 months ago