Run in Enrichment Spreadsheet
Use this function as a column step in
deepline enrich.deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=clickhouse_click_pipe_settings_update:{"organizationId":"{{organizationId}}","serviceId":"{{serviceId}}","clickPipeId":"{{clickPipeId}}"}' --json
Map payload values to spreadsheet columns with
{{column_name}} placeholders.Input Schema
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
payload.organizationId | string | Yes | ID of the organization that owns the service. | |
payload.serviceId | string | Yes | ID of the service that owns the ClickPipe. | |
payload.clickPipeId | string | Yes | ID of the ClickPipe to update settings for. | |
payload.streaming_max_insert_wait_ms | integer | No | Streaming max insert wait time. Configures the max wait period before inserting data into the ClickHouse. | |
payload.object_storage_concurrency | integer | No | Object storage concurrency. Number of concurrent file processing threads | |
payload.object_storage_polling_interval_ms | integer | No | Object storage polling interval. Configures the refresh interval for querying continuous ingest for new object storage data | |
payload.object_storage_max_insert_bytes | integer | No | Max insert bytes. Number of bytes to process in a single insert batch | |
payload.object_storage_max_file_count | integer | No | Max file count. Maximum number of files to process in a single insert batch | |
payload.clickhouse_max_threads | integer | No | Max threads. Maximum number of concurrent threads for file processing | |
payload.clickhouse_max_insert_threads | integer | No | Max insert threads. Maximum number of concurrent insert threads | |
payload.clickhouse_min_insert_block_size_bytes | integer | No | Min insert block size bytes. Minimum size of data block for insert (in bytes) | |
payload.clickhouse_max_download_threads | integer | No | Max download threads. Maximum number of concurrent download threads | |
payload.clickhouse_parallel_distributed_insert_select | integer | No | Parallel distributed insert select. Parallel distributed insert select setting | |
payload.object_storage_use_cluster_function | boolean | No | use cluster function. Whether to use ClickHouse cluster function for distributed processing | |
payload.clickhouse_parallel_view_processing | boolean | No | parallel view processing. Whether to enable pushing to attached views concurrently instead of sequentially |
Output Schema
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
result.data | object | Yes | Provider response payload. | |
result.meta | object | No | Additional response metadata (status, paging). |
Advanced: Direct CLI
Use direct execution for single payload debugging.
deepline tools execute clickhouse_click_pipe_settings_update --payload '{
"organizationId": "string",
"serviceId": "string",
"clickPipeId": "string"
}' --json
CLI flags
| Flag | Description |
|---|---|
--json | Print machine-readable output. |
--wait | Wait for terminal provider status when supported. |
--debug | Enable wait mode with additional status/log output. |
--wait-timeout SECONDS | Max seconds to wait in wait mode. |
--poll-interval SECONDS | Polling interval in seconds during wait mode. |
--timeout SECONDS | Request timeout in seconds. |
--connect-timeout SECONDS | Connection timeout in seconds. |
Cost
- Pricing model:
fixed(per call). - Estimated Deepline credits:
0per pricing unit. - Provider-native pricing may still exist outside Deepline credit billing.
- Billing mode:
no_bill.