Skip to content

Register MySQL Node

Data/DataFusion/Databases

Register MySQL

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

df_register_mysqldata
Inputs11
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.
3/10High
GovernancePolicy, audit, or compliance impact.
3/10High
ReliabilityOperational stability considerations.
2/10High
CostExternal or compute cost impact.
3/10High

Input Pins

11

Input

Execution
exec_in

Trigger execution

Session

Struct
session

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Host

String
host

MySQL server host

Default localhost

Port

Integer
port

MySQL server port

Default 3306

Database

String
database

Database name

Username

String
username

Database username

Password

String
password

Database password

Source Table

String
source_table

Name of the table in MySQL

Table Name

String
table_name

Name to register in DataFusion

SSL Mode

String
ssl_mode

SSL mode: disabled, preferred, required

Default preferred

Read Only

Boolean
readonly

Open connection in read-only mode

Default true

Output Pins

3

Done

Execution
exec_out

Table registered

Session

Struct
session_out

DataFusion session

DataFusionSessionDataFusionSession1 fields
cache_keystringrequired

Connection URL

String
connection_url

Generated connection URL

Node Info

Internal name
df_register_mysql
Category
Data/DataFusion/Databases