Description

For GenericSQLInsert Receivers, the Column Type Property Key has a finite set of values that work with most SQL databases.

• Column Type
  • String - gets translated to a VARCHAR
  • Boolean - native data type
  • BigDecimal - gets translated to a DECIMAL
  • Blob - Binary Large Objects
  • JsonB - stores JSON data in a binary format, which enables faster indexing and query performance compared to the regular JSON data type
  • Date - native data type
  • Double-native data type
  • Float - native data type
  • Integer - native data type
  • Long - gets translated to a BIGINT
  • Time - native data type
  • Timestamp - native data type
  • Varbinary - gets translated to Bytes
  • UUID - parses a generated UUID string value into a UUID object before inserting it into the table column
  • Other - handles other data types