I'm trying to create an UPDATE statement in the SQL component in Matillion however I get a syntax error at SET.
UPDATE matchingmanufacturernofulllast2
SET "matchingmanufacturernofulllast2.available" = 'f'
where listprice is not null
ERROR: syntax error at or near "SET"
Position: 88
Does Matillion sql component have the ability to use the sql UPDATE syntax?
Regards Conteh
Use the SQL orchestration component for DDL. The SQL transformation component is for Select only.