I'm trying to put an update query in a SQL component. Is that not supported? Even with very simple updates, the component won't validate, giving me an error: "Validation error. Could not retrieve metadata from this query." And if I try to run it from inside the component, I get a syntax error. But if I copy the SQL from the component's SQL tab, I can run it just fine directly in Redshift.
I thought perhaps updates just weren't supported in this component, but the documentation (and other questions in the forums) suggest that they are.
4 Community Answers
Kalyan Arangam —
I think you are referring to documentation on “SQL Script” orchestration component instead of “SQL” transformation component.
The “SQL” transformation component cannot be used for DML. Only SELECTS are allowed. You may use DML/DDL statements in the “SQL Script” orchestration component.