Generated Records
The SQL Parser parses a SQL query in a field and creates fields based on the query. The processor also includes the CRUD operation type in the sdc.operation.type record header attribute. This enables CRUD-enabled destinations to determine the operation type to use when processing records.
When configuring the SQL Parser, you specify the field containing the SQL query. For
example, if the SQL Parser processes the following SQL query statement located in the
/sql
field:INSERT INTO "sdc"."mc"("Part", "Cost") VALUES('levers', 250)It writes the following fields to the record:
| Part | Cost |
|---|---|
| levers | 250 |
If the Part and Cost field already exist, the processor overwrites those fields. If they do not exist, the processor creates them.
SQL Parser supports the following operations:
- INSERT
- UPDATE
- DELETE