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

Database Query Component - customize target table

I'd like to load all the tables from a MySQL DB to Redshift. I don't see how I can use the Database Query Component to do all of the tables since Target Table isn't customizable. What am I missing?

2 Community Answers

Muness Castle —

Never mind: even though Use variable isn't an option, you can reference a variable in the SQL and target table parameters as expected. ${<variable name>}

Matillion Agent  

Ian Funnell —

Hi Muness,

Thanks for confirming you have it working.

Best regards,

Post Your Community Answer

To add an answer please login