SQL output
SQL output — sqlOutput
Write the result to a database table via a reusable Connection.
SQL Input
raw orders
Drop Nulls
Calculated Column
total = price × qty
SQL Output
cleaned_orders — append
Use cases
- Land a cleaned dataset into an analytics table on a schedule.
- Append daily results to a growing table, or replace a table each run.
Configuration
| Config key | Type | Required | Description |
|---|---|---|---|
connection_id | string | Yes | The connection to write to |
table | string | Yes | Target table |
schema | string | No | Schema to write into |
if_exists | string | No | replace (default), append, or fail |
Generated Python code
df_5.to_sql("cleaned_orders", _engine_1, if_exists="replace", index=False)
Security
Exported code never embeds the password — it resolves the connection's secret
reference at runtime (os.environ[...] for env:/bare names,
keyring.get_password(...) for keyring:NAME, or a file:/path read for a
mounted secret file). See Connections.
Tips & common mistakes
replacedrops and recreates the table (and its schema/indexes). Useappendto keep an existing table and add rows;failto abort if it exists.- Match the table's columns. With
append, the frame's columns should line up with the target table.