Can you create a SQL Update statement in Matillion?

Question

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

What's the underlying DB this statement is aimed at?

Eric Hauenstein
– Eric Hauenstein

2020-07-27 19:55:13 +00:00
Commented Jul 27, 2020 at 19:55 — Eric Hauenstein
– Eric Hauenstein, Commented Jul 27, 2020 at 19:55
@ericHauenstein it's aimed at redshift

conteh
– conteh

2020-07-27 23:17:12 +00:00
Commented Jul 27, 2020 at 23:17 — conteh
– conteh, Commented Jul 27, 2020 at 23:17

nofinator · Accepted Answer · 2020-09-21 15:27:42Z

4

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

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

edited Sep 21, 2020 at 15:27

nofinator

3,05323 silver badges30 bronze badges

answered Sep 14, 2020 at 13:31

Andrew Helms

564 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

conteh · Accepted Answer · 2020-07-27 23:27:22Z

0

One option to create an update statement with a where clause in Matillion is to use the calculator component in conjuction with a case expression

CASE
WHEN ("listprice" is not null)
THEN 'F'
END

answered Jul 27, 2020 at 23:27

conteh

1,6343 gold badges21 silver badges43 bronze badges

Collectives™ on Stack Overflow

Can you create a SQL Update statement in Matillion?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related