ContributionsMost RecentMost LikesSolutionsRe: Snaplogic Redshift Copy Command Thanks @mbowen This helps… !! Snaplogic Redshift Copy Command Hi Team, When I read data from a file/csv and do a bulk load, into redshift I know that at the backend it’s trying to copy the data and tries to do the bulk load. Here…I need to know what was the full set of options the Snaplogic code used for the Redshift Copy command at its backend. Where I can get that details… Thanks in advance. Makesh SolvedKaltura data How to extract - Kaltura source system data – Do we have a generic way of reading the datasets. Re: Redshift bulk load @koryknick Thanks for the suggestion … !! keeping this in y note…! Re: Redshift bulk load so … this gave me the solution $content.contains(‘\r\n’)? ($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) : $content.replaceAll(‘\n’,‘\n’) Re: Redshift bulk load Well, thanks for coming back @mbowen … my target is redshift … I will be getting the file from the win / Unix system and blow will be its behaviour Win Unix I am trying to read the csv file irrespective of the system i am using the blow code for replacing the \r\n – ($content.replaceAll(‘\r\n’,‘\n’) && $content.replaceAll(‘\n’,‘’) ) Problem - when I pass the Unix file it replaces the \n to ‘’ and makes the csv invalid. how to accommodate them both Redshift bulk load Hi team, Looking for a suggestion/enhancement to achieve the below senario. when i read a csv file (it might have \n\r (windows) & \n(unix) ). Who to fix this … Today I read the file and when I do the bulk load using redshift bulk load snap and the data gets loaded with the \n\r . How can I escape these characters? When i look at the properties of the snap , i could see the below. but it’s not working. Solved