Integrating with ClickHouse Cloud

More connectors will get added to ClickPipes, you can find out more by [contacting us](https://clickhouse.com/company/contact?loc=clickpipes).

## List of Static IPs[​](#list-of-static-ips "Direct link to List of Static IPs")

The following are the static NAT IPs (separated by region) that ClickPipes uses to connect to your external services. Add your related instance region IPs to your IP allow list to allow traffic. In the case of object storage pipes you should also add the [ClickHouse cluster IPs](/docs/manage/data-sources/cloud-endpoints-api) to your IP allow list.

For all services, ClickPipes traffic will originate from a default region based on your service's location:

- **eu-central-1**: For all EU regions not explicitly listed (including GCP and Azure EU regions).
- **eu-west-1**: For all services in AWS `eu-west-1` created on or after 20 Jan 2026 (services created before this date use `eu-central-1` IPs).
- **us-east-1**: For all services in AWS `us-east-1`.
- **ap-south-1**: For services in AWS `ap-south-1` created on or after 25 Jun 2025 (services created before this date use `us-east-2` IPs).
- **ap-northeast-2**: For services in AWS `ap-northeast-2` created on or after 14 Nov 2025 (services created before this date use `us-east-2` IPs).
- **ap-southeast-1**: For services in AWS `ap-southeast-1` created on or after 18 Mar 2026 (services created before this date use `us-east-2` IPs).
- **ap-southeast-2**: For services in AWS `ap-southeast-2` created on or after 25 Jun 2025 (services created before this date use `us-east-2` IPs).
- **ap-southeast-3**: For services in AWS `ap-southeast-3` created on or after 6 Mar 2026 (services created before this date use `us-east-2` IPs).
- **us-west-2**: For services in AWS `us-west-2` created on or after 24 Jun 2025 (services created before this date use `us-east-2` IPs).
- **us-east-2**: For all other regions not explicitly listed (including GCP and Azure regions).

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| AWS region IP Addresses|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | **eu-central-1** - Frankfurt `18.195.233.217`, `3.127.86.90`, `35.157.23.2`, `18.197.167.47`, `3.122.25.29`, `52.28.148.40`| **eu-west-1** - Ireland (from 20 Jan 2026) `54.228.1.92` , `54.72.101.254`, `54.228.16.208`, `54.76.200.104`, `52.211.2.177`, `54.77.10.134`| **us-east-1** - N. Virginia `54.82.38.199`, `3.90.133.29`, `52.5.177.8`, `3.227.227.145`, `3.216.6.184`, `54.84.202.92`, `3.131.130.196`, `3.23.172.68`, `3.20.208.150`| **us-east-2** - Ohio `3.131.130.196`, `3.23.172.68`, `3.20.208.150`, `3.132.20.192`, `18.119.76.110`, `3.134.185.180`| **ap-south-1** - Mumbai (from 25 Jun 2025) `13.203.140.189`, `13.232.213.12`, `13.235.145.208`, `35.154.167.40`, `65.0.39.245`, `65.1.225.89`| **ap-northeast-2** - Seoul (from 14 Nov 2025) `3.38.68.69`, `52.78.68.128`, `13.209.152.13`, `3.38.24.84`, `3.37.159.31`, `3.34.25.104`| **ap-southeast-1** - Singapore (from 18 Mar 2026) `13.215.65.134`, `18.139.118.108`, `47.130.197.47`, `54.251.134.219`, `54.254.98.29`, `54.255.153.106`| **ap-southeast-2** - Sydney (from 25 Jun 2025) `3.106.48.103`, `52.62.168.142`, `13.55.113.162`, `3.24.61.148`, `54.206.77.184`, `54.79.253.17`| **ap-southeast-3** - Jakarta (from 6 Mar 2026) `16.78.195.195`, `43.218.184.235`, `16.79.88.54`, `16.78.153.162`, `16.79.6.125`, `108.137.52.155`| **us-west-2** - Oregon (from 24 Jun 2025) `52.42.100.5`, `44.242.47.162`, `52.40.44.52`, `44.227.206.163`, `44.246.241.23`, `35.83.230.19` | | | | | | | | | | | | | | | | | | | | | |

## Adjusting ClickHouse settings[​](#adjusting-clickhouse-settings "Direct link to Adjusting ClickHouse settings")

ClickHouse Cloud provides sensible defaults for most of the use cases. However, if you need to adjust some ClickHouse settings for the ClickPipes destination tables, a dedicated role for ClickPipes is the most flexible solution.
Steps:

1. create a custom role `CREATE ROLE my_clickpipes_role SETTINGS ...`. See [CREATE ROLE](/docs/sql-reference/statements/create/role) syntax for details.
2. add the custom role to ClickPipes user on step `Details and Settings` during the ClickPipes creation.

## Adjusting ClickPipes advanced settings[​](#clickpipes-advanced-settings "Direct link to Adjusting ClickPipes advanced settings")

ClickPipes provides sensible defaults that cover the requirements of most use cases. If your use case requires additional fine-tuning, you can adjust the following settings:

### Object storage ClickPipes[​](#clickpipes-advanced-settings-object-storage "Direct link to Object storage ClickPipes")

|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Setting Default value Description|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `Max insert bytes` 10 GB Number of bytes to process in a single insert batch.|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `Max file count` 100 Maximum number of files to process in a single insert batch.|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `Max threads` auto(3) [Maximum number of concurrent threads](/docs/operations/settings/settings#max_threads) for file processing.| `Max insert threads` 1 [Maximum number of concurrent insert threads](/docs/operations/settings/settings#max_insert_threads) for file processing.| `Min insert block size bytes` 1 GB [Minimum size of bytes in the block](/docs/operations/settings/settings#min_insert_block_size_bytes) which can be inserted into a table.| `Max download threads` 4 [Maximum number of concurrent download threads](/docs/operations/settings/settings#max_download_threads).| `Object storage polling interval` 30 s Configures the maximum wait period before inserting data into the ClickHouse cluster.|  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | `Parallel distributed insert select` 2 [Parallel distributed insert select setting](/docs/operations/settings/settings#parallel_distributed_insert_select).| `Parallel view processing` false Whether to enable pushing to attached views [concurrently instead of sequentially](/docs/operations/settings/settings#parallel_view_processing).| `Use cluster function` true Whether to process files in parallel across multiple nodes. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |

### Streaming ClickPipes[​](#clickpipes-advanced-settings-streaming "Direct link to Streaming ClickPipes")

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| Setting Default value Description|  |  |  | | --- | --- | --- | | `Streaming max insert wait time` 5 s Configures the maximum wait period before inserting data into the ClickHouse cluster. | | | | | |

## Error reporting[​](#error-reporting "Direct link to Error reporting")

ClickPipes will store errors in two separate tables depending on the type of error encountered during the ingestion process.

### Record errors[​](#record-errors "Direct link to Record errors")