matillion

Can you create a SQL Update statement in Matillion?


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


Solution

  • Use the SQL orchestration component for DDL. The SQL transformation component is for Select only.

    https://documentation.matillion.com/docs/2107012