topic Redshift Relation does not exist in Talend Studio

Redshift Relation does not exist

Naresh3 — Mon, 22 Sep 2014 12:23:57 GMT

Hi all,
While loading the data from one schema to another schema using talend,i am getting below error.
Error : relation "customer" does not exist
Can some one guide me where i am going wrong. Is it a problem with Access permissions?

Thanks in advance

Re: Redshift Relation does not exist

Anonymous — Thu, 09 Oct 2014 04:08:45 GMT

Hi,
Did you use double quote when create table or execute query? Please upload your https://community.talend.com/t5/Design-and-Development/Redshift-Relation-does-not-exist/td-p/58275 component setting screenshot so that we can address your issue quickly.
Best regards
Sabrina

Re: Redshift Relation does not exist

_AnonymousUser — Wed, 15 Mar 2017 06:57:52 GMT

Any luck in this issue?.can u please suggest if talend is the right option to load data from one schema of redshift to other schema in redshift due to performance .i have a Big SQl with many joins where i want to execute this SQL using talend and schedule it..can u ps sugest the right design?

Re: Redshift Relation does not exist

vapukov — Wed, 15 Mar 2017 07:22:03 GMT

Any luck in this issue?.can u please suggest if talend is the right option to load data from one schema of redshift to other schema in redshift due to performance .i have a Big SQl with many joins where i want to execute this SQL using talend and schedule it..can u ps sugest the right design?

no any issues the (and wasn't), what is Your problem?
the performance of Big Query with many JOINS always depends from database, but not from Talend
So, what is full design of You Job and what You see as trouble?