Alteryx Designer: loading data with a backslash in Amazon Redshift Bulk Load

[junyak]

How to: load data with backslash ("\") in Amazon Redshift Bulk Load

When you load data containing a string ending with backslash ("\") in Amazon Redshift Bulk Load, this will be showing (\\) in Redshift. This is because backslash ("\") introduces escape sequences in Redshift Bulk Loader.

e.g. a record "ABCD\" turns to "ABCD\\"


Prerequisites 

• Product - Alteryx Designer (all) 
• Amazon Redshift Bulk Connection

Solution

• Replace all backslash ("\") with double backslash ("\\"), then load via Amazon Redshift Bulk Load.
      e.g. (Replace([Your_Field],"\","\\")

Additional Notes
AWS - https://docs.aws.amazon.com/redshift/latest/dg/copy-parameters-data-conversion.html#copy-escape