Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Table Iterator to Dump data from teradata to Redshift

I am using Table Iterator on top of DB connector (Teradata) with one Table input to iterate table_name one by one and dump data from terdata to redshift Target table. which seems working and iterating on tables with feed sql (select * from ) but some how copy statement is not loading any data.
Can any one please suggest.

4 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Ravi,

Do you see any errors?

I’ve only seen this when we do not pull any data from source.
Are you able to share your log file from Admin menu?

Best
Kalyan


Ravi Kumar —

Hi Kalyan,

Don't see any error, Task status says the count of the source table but no error. I have checked the log with copy statement generating after every iteration.How do I debug or Any other approach to load data from teradata to redshift with list of tables .Please suggest.


Matillion Agent  

Kalyan Arangam —

Hi Ravi Kumar,

Please share your logs from the Admin menu. I am hoping there may be some messages in it.

On loading multiple tables, please see the following article.

https://redshiftsupport.matillion.com/customer/portal/articles/2870116?b_id=8915

The article discusses using an RDS instance as source but the same can be applied to a Database Query component which is connecting to Teradata.

Hope that makes sense.

Best
Kalyan


Ravi Kumar —

Thanks Kalyan, Created a support ticket to upload log files, Please check.

Post Your Community Answer

To add an answer please login