Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.

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

Alteryx Alumni (Retired)
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\\"

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

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