Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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 "'
My query:
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 ?
Thank you
Hello,
Are you using talend component tRedshiftUnload? Screenshots of your component setting will be preferred.
Can you successfully unload your file without header in talend?
Best regards
Sabrina
Hi Sabrina,
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.
Thank you
Hello,
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?
Best regards
Sabrina
hi ,
I am facing the single quotes issue in where clause as in attachment.
please help me out
Hello @harshadathorat ,
Could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line?
Best regards
Sabrina
Is there still a way to get headers in the delimited file using "tredshiftunload" component ??
Hello,
So far, we won't do this new feature and we are relying on Amazon for this feature request.
A workaround exists by leveraging custom SQL with Union in order to add the header.
Let us know if it is OK with you.
Best regards
Sabrina
Hi Sabrina,
Thank you for your reply. But looking at amazon unload command it has an option to enable the headers. Please refer to this link . Can we also get an option to enable the headers in the tredshiftunload component ? The header option which amazon provides it writes the header into all the files which are split. In case of Union it will write the header only to first page/file only.
As my requirement is to have the headers in all the files. Please let me know how can we achieve this as each file is having a size of 6.2 GB ?
Regards,
Rahul