I'm trying to insert an SQL result which I got, from a join operation into a Redshift table.
But the SQL editor isn't picking the INSERT keyword? Is it possible to do an INSERT within the SQL component available in the transformations?
The error I ger "ERROR: syntax error at or near "into""
Any help would be appreciated.
2 Community Answers
Kalyan Arangam —
The SQL Transformation component does not support DML. You may only write SELECT statements in the SQL Transformation component.
Why not direct the result of your transform to a Table Output component which will perform an insert of the incoming data?