Setup Requirements
List of required items to use Coalesce in your organization
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