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

Loading To S3

We are working on a proof of concept to load data from our source system (MySQL) to S3 and not load the raw data to Redshift, but create external tables in redshift to S3. Are there any components in Matillion that allow a such a process. I can only find a component to unload Redshift data to S3 and all the source system components write to S3 then load into Redshift, I would like to not write to Redshift . . any thoughts ?

1 Community Answers

Matillion Agent  

Paul Johnson —

Hi Chris,
Yes all you need to do is select external on the “Type” property of the database query component and this will change a few of the options so you can select an s3 bucket to land the data.

Regards,
Paul

Post Your Community Answer

To add an answer please login