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

Redshift to CSV

Hi,

How to move redshift table to s3 bucket "csv" file in matillion.

Thanks,

Mathan

4 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Mathan,

We have two components to export data into S3. Please see the below links for more information on these components.

  1. S3 UNLOAD – https://redshiftsupport.matillion.com/customer/portal/articles/2167231
  2. TEXT OUTPUT – https://redshiftsupport.matillion.com/customer/en/portal/articles/2703150-text-output

Hope that helps.

Best
Kalyan


Mathan Selvaraj —

Hi Kalyan,

Thanks for this link.... But, it takes all fields.

I want to load some particular fields..

If table have 10 fields , i want to move only 5 fields.

Thanks,

Mathan


Matillion Agent  

Kalyan Arangam —

Hi,

You may need to create a view in Redshift that has just these 5-fields and then use that view as the source in these components.

Best
Kalyan


Mathan Selvaraj —

Hi Kalyan,

Thanks a lot to clear my issue..

Thanks,

Mathan

Post Your Community Answer

To add an answer please login