Redshift Issue

snarayanane

Currently, all the output datasets generated by Redshift contains the column names in lower case only.

 

Example: store_name, product_name etc.

 

However, the values inside these columns contain both lower case and upper case.  Require an option of converting the column names into upper case like  STORE_NAME, PRODUCT_NAME etc.  This will ensure smooth usage of page level filters.  At present page level filters consider STORE_NAME and store_name to be distinct columns (when they are the same in reality)

btm

Thank you for submitting this @snarayanane. I am assigning to our product manager @StevenC to review and comment.

StevenC

@snarayanane Thanks for sending in this great suggestion for handling case in RedShift.  We will consider this request as we continue to improve and build out DataFlows.

StevenC