Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Why INSERT not working in SQL?

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.

Thanks

2 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Kulasangar,

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?

Best
Kalyan


Kulasangar Gowrisangar —

Thanks, Kalyan!

Post Your Community Answer

To add an answer please login