am using redshift.i used select query in unload component in talend.
it was working in redshift but in talend its not working .I was getting an error
unterminated quoted string at or near "'
select campaignid,code,' 'as campainmember,' ' as lead,''sun'' as leadname from ms_is.bystyn.
is there any one to unload the file with header?
can anyone help me ?
Are you using talend component tRedshiftUnload? Screenshots of your component setting will be preferred.
Can you successfully unload your file without header in talend?
am using talend (tredshiftunload)component.but i am getting some errors. (')single quotes is not working in talend.so, is there any other way to unload the table in s3 path.
kindly provide any solution ? and thanks For the reply.please find the screenshots.
Have you tried to use sql query like:
select campaignid,code, as campainmember, as leadsun, as leadname from ms_is.bystyn without (')single quotes to see if it works?
Which is talend build version you are using?