Register FlightSQL Node

R

Data/DataFusion/Databases

Register FlightSQL

Register a table via Arrow Flight SQL protocol. High-performance columnar data transfer (10-100x faster than JDBC/ODBC). Supports Dremio, InfluxDB, DuckDB Flight, ClickHouse Flight, and more.

df_register_flightsqldata

Inputs10

Outputs3

Security exposure3/10

Packagedata

Ratings

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

SecurityAttack surface and exposure impact.

3/10High

PrivacyPotential sensitivity of processed data.

4/10Medium

PerformanceRuntime or resource pressure.

0/10High

GovernancePolicy, audit, or compliance impact.

3/10High

ReliabilityOperational stability considerations.

2/10High

CostExternal or compute cost impact.

2/10High

Input Pins

10

Input

Execution

exec_in

Trigger execution

Session

Struct

session

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Host

String

host

Flight SQL server host

Default localhost

Port

Integer

port

Flight SQL server port (typically 443 for TLS, or service-specific)

Default 443

Username

String

username

Username for authentication (optional)

Password/Token

String

password

Password or bearer token for authentication (optional)

Query

String

query

SQL query to execute (e.g., SELECT * FROM my_table)

Table Name

String

table_name

Name to register the query result in DataFusion

Use TLS

Boolean

use_tls

Enable TLS/SSL encryption for the connection

Default true

Skip TLS Verify

Boolean

skip_verify

Skip TLS certificate verification (for self-signed certs)

Default false

Output Pins

3

Done

Execution

exec_out

Table registered

Session

Struct

session_out

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Endpoint

String

endpoint

Flight SQL endpoint URL

Node Info

Internal name

df_register_flightsql

Category

Data/DataFusion/Databases