coalesce.io

Setup Requirements

List of required items to use Coalesce in your organization

Suggest Edits

Network

🚧

Action Required

Update Your Network Policies

We are expanding our network to provide continually uninterrupted service to our customers.

From February 1, 2024 onwards, Coalesce will have additional outgoing IP addresses.

Please update your network policies to allow traffic to our new IP addresses before February 1 to avoid interruptions in service.

If you require assistance during this transition, please reach out to our support team at [email protected].

Allow Inbound Traffic from Coalesce

When using Coalesce SaaS, we will connect to Snowflake from the following IP addresses. Be sure to allow traffic from all IPs in the respective Coalesce region by locating your domain (URL) below:

US Primary

Domain: app.coalescesoftware.io

Cloud Provider: Google Cloud Platform

Region: US Central 1

IP Addresses

35.184.36.82
34.122.41.172
104.197.181.174
104.197.239.181
34.42.195.106
34.68.106.79
34.68.120.84
35.223.203.238
34.132.232.62
34.123.199.186
34.30.33.202
35.193.16.39
35.239.135.16
34.41.250.208
35.222.123.215
34.121.9.26

Snowflake Network Policy Definition

CREATE OR REPLACE NETWORK POLICY COALESCE_GCP_US_CENTRAL_1 
ALLOWED_IP_LIST = ( 
	'35.184.36.82',
	'34.122.41.172',
	'104.197.181.174',
	'104.197.239.181',
	'34.42.195.106',
	'34.68.106.79',
	'34.68.120.84',
	'35.223.203.238',
	'34.132.232.62',
	'34.123.199.186',
	'34.30.33.202',
	'35.193.16.39',
	'35.239.135.16',
	'34.41.250.208',
	'35.222.123.215',
	'34.121.9.26'
);

Europe Primary

Domain: app.eu.coalescesoftware.io

Cloud Provider: Google Cloud Platform

Region: Europe West 3

IP Addresses

34.89.191.247
34.89.148.26
35.246.145.217
34.141.50.108
34.159.114.61
35.198.174.119
34.159.236.68
34.141.97.246
34.141.85.173
34.159.92.100
35.234.79.196
35.246.181.59
34.159.213.117
35.198.149.245
35.198.130.208
34.159.109.127

Snowflake Network Policy Definition

CREATE OR REPLACE NETWORK POLICY COALESCE_GCP_EUROPE_WEST_3 
ALLOWED_IP_LIST = ( 
	'34.89.191.247',
	'34.89.148.26',
	'35.246.145.217',
	'34.141.50.108',
	'34.159.114.61',
	'35.198.174.119',
	'34.159.236.68',
	'34.141.97.246',
	'34.141.85.173',
	'34.159.92.100',
	'35.234.79.196',
	'35.246.181.59',
	'34.159.213.117',
	'35.198.149.245',
	'35.198.130.208',
	'34.159.109.127' 
);

Australia Primary

Domain: app.australia-southeast1.gcp.coalescesoftware.io

Cloud Provider: Google Cloud Platform

Region: Australia Southeast 1

IP Addresses

34.116.123.45
34.116.78.163
35.244.80.87
34.116.95.120
35.201.3.42
35.244.92.117
35.197.183.131
34.116.87.108
35.189.42.234
35.201.8.86
35.189.32.148
34.116.82.99
34.116.110.251
34.87.228.146
35.197.168.207
35.244.65.40

Snowflake Network Policy Definition

CREATE OR REPLACE NETWORK POLICY COALESCE_GCP_AUSTRALIA_SOUTHEAST_1 
ALLOWED_IP_LIST = ( 
	'34.116.123.45',
	'34.116.78.163',
	'35.244.80.87',
	'34.116.95.120',
	'35.201.3.42',
	'35.244.92.117',
	'35.197.183.131',
	'34.116.87.108',
	'35.189.42.234',
	'35.201.8.86',
	'35.189.32.148',
	'34.116.82.99',
	'34.116.110.251',
	'34.87.228.146',
	'35.197.168.207',
	'35.244.65.40' 
);

US AWS East

Domain: app.us-east-1.aws.coalescesoftware.io

Cloud Provider: Amazon Web Services

Region: US East 1

IP Addresses

54.164.136.234
54.204.122.114
35.153.45.74
3.222.28.181
54.162.41.198
54.237.34.70
44.218.190.25
44.214.13.195
3.233.107.188
52.203.105.88
44.214.198.37
23.21.137.7
18.214.188.200
34.234.18.234
34.232.239.54

Snowflake Network Policy Definition

CREATE OR REPLACE NETWORK POLICY COALESCE_GCP_US_EAST_1 
ALLOWED_IP_LIST = ( 
	'54.164.136.234',
	'54.204.122.114',
	'35.153.45.74',
	'3.222.28.181',
	'54.162.41.198',
	'54.237.34.70',
	'44.218.190.25',
	'44.214.13.195',
	'3.233.107.188',
	'52.203.105.88',
	'44.214.198.37',
	'23.21.137.7',
	'18.214.188.200',
	'34.234.18.234',
	'34.232.239.54' 
);

US AWS West

Domain: app.us-west-2.aws.coalescesoftware.io

Cloud Provider: Amazon Web Services

Region: US West 2

IP Addresses

52.34.52.101
54.245.169.140
52.40.254.45
54.184.34.110
54.218.245.200
44.230.62.194
44.236.171.53
52.38.24.181
52.33.89.80
52.37.156.238
44.224.250.156
35.155.62.60
34.212.220.146
35.164.137.106
34.212.187.109

Snowflake Network Policy Definition

CREATE OR REPLACE NETWORK POLICY COALESCE_AWS_US_WEST_2 
ALLOWED_IP_LIST = ( 
	'52.34.52.101',
	'54.245.169.140',
	'52.40.254.45',
	'54.184.34.110',
	'54.218.245.200',
	'44.230.62.194',
	'44.236.171.53',
	'52.38.24.181',
	'52.33.89.80',
	'52.37.156.238',
	'44.224.250.156',
	'35.155.62.60',
	'34.212.220.146',
	'35.164.137.106',
	'34.212.187.109'
);

📘

In-Network Command-Line Interface

The Coalesce Command-Line Interface may be used to deploy and run Jobs in an 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 Snowflake warehouse.

Allow Outbound Traffic to Coalesce

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://identitytoolkit.googleapis.com/
https://securetoken.googleapis.com/
https://storage.coalescesoftware.io/

https://app.coalescesoftware.io
https://*.app.coalescesoftware.io
https://app.eu.coalescesoftware.io/
https://*.app.eu.coalescesoftware.io/
https://app.australia-southeast1.gcp.coalescesoftware.io/
https://*.app.australia-southeast1.gcp.coalescesoftware.io/
https://app.us-east-1.aws.coalescesoftware.io/
https://*.app.us-east-1.aws.coalescesoftware.io/
https://app.us-west-2.aws.coalescesoftware.io/
https://*.app.us-west-2.aws.coalescesoftware.io/

Authentication

Single Sign-On to Coalesce

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.

Snowflake OAuth to Coalesce

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.

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.

Other

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

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

Updated 25 days ago