Redshift Bulk Loader Additional Parameters

[joao]

On the RedShift Bulk Loader add support for Redshift options:

http://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html

• TRUNCATECOLUMNS (automatically truncates any fields to the defined in the table)
• IGNOREBLANKLINES
• FILLRECORD
• TIMEFORMAT
• TRIMBLANKS
• ENCODING
• EMPTYASNULL
• DATEFORMAT

...

[justin_winter]

Of these, for our use cases, it would seem that encoding would be a huge win here for us. Our IT has had tok go back and manually encode some of our larger tables for us and it makes Alteryx look unsophisticated to our IT department. Seems like this should be super easy since Alteryx is presumably running a copy command from S3 anyway and adding the "CompUpdate On" flag would be all that would be needed for basic functionality.

Thanks!

[frankndavis]

I would second or third the need for COMPUPDATE option for the COPY command in order to enable automatic compression in redshift.  Is this available yet as a configurable feature.

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!