Skip to main content

SQL Insert

Inserts rows into a SQL database.

FieldTypeDefaultDescription
DriverstringDatabase driver
DSNstringConnection string
TablestringTarget table
ColumnsarrayColumn names
Args MappingBloblangMaps message fields to column values
SuffixstringOptional SQL suffix (e.g., ON CONFLICT DO NOTHING)
Max In Flightinteger64Maximum parallel inserts
BatchingobjectBatching policy

Supported drivers: mysql, postgres, clickhouse, mssql, sqlite, oracle, snowflake, trino, cosmos, spanner.