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

Insert data to Redshift

My job is going to receive an SQS message then assign to an "Environment Variables" in Matilion project. Does any way that I can insert the value of "Environment Variables" which is text format to Redshift table? Thank you.

2 Community Answers

Matillion Agent  

Laura Malins —

Hi Jerry

Apologies I’m not sure I understand your question. Are you asking if you can insert values of an environment variable into a table? This is possible if you format the values in the variable correctly and use it in a SQL script component in an Orchestration job. For example I have a variable called ${table} which has the value: (‘C’,2),(‘D’,3),(‘E’,4) which are the 3 rows of data I want to insert.

I can then use the below script in the SQL component.
INSERT INTO book1 VALUES
${table};

Thanks
Laura


Jerry Cheng —

thank you that is what I am looking for.

Post Your Community Answer

To add an answer please login