Register ClickHouse Node

R

Data/DataFusion/Databases

Register ClickHouse

Register a ClickHouse table for federated queries. Uses real database connection for full SQL push-down.

df_register_clickhousedata

Inputs10

Outputs3

Security exposure4/10

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

SecurityAttack surface and exposure impact.

4/10Medium

PrivacyPotential sensitivity of processed data.

5/10Medium

PerformanceRuntime or resource pressure.

0/10High

GovernancePolicy, audit, or compliance impact.

3/10High

ReliabilityOperational stability considerations.

2/10High

CostExternal or compute cost impact.

3/10High

Input Pins

10

Input

Execution

exec_in

Trigger execution

Session

Struct

session

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Host

String

host

ClickHouse server host

Default localhost

Port

Integer

port

ClickHouse HTTP port

Default 8123

Database

String

database

Database name

Default default

Username

String

username

Database username

Default default

Password

String

password

Database password

Source Table

String

source_table

Name of the table in ClickHouse

Table Name

String

table_name

Name to register in DataFusion

Read Only

Boolean

readonly

Use read-only queries

Default true

Output Pins

3

Done

Execution

exec_out

Table registered

Session

Struct

session_out

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Connection URL

String

connection_url

Generated connection URL

Node Info

Internal name

df_register_clickhouse

Category

Data/DataFusion/Databases