Orchestration Components

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....

JDBC Incremental load component

How to use JDBC Incremental load component

Handling 404 Error on API Query

Hi, I have an Table Iterator that runs over a table with a column like "item_id". Each iteration calls an API Query component, which uses the "item_id" as a parameter...

Replace a connection string in database query component with a variable?

Hi All, I'm currently operating in an environment where I am going to be extracting ~25 tables from a source system hosted on Heroku. Due to how Heroku operates with...

Send Email with Python Script

I want to send an email using Python Script, I run the code in edit properties of the script and it said "mail send" but i don't receive the email....

Table Iterator with more than 5,000 rows?

Hi, I am testing a new job that uses a table iterator, iterating over a large table (> 5,000 rows). When I started testing, I noticed in the Task History...

Access data in different Redshift database?

Hi, If I am using Matillion...connected to a given Redshift "environment"...then is there a way to access data in another Redshift cluster? Or, the same Redshift cluster but a different...

Read from Redshift table using Python component

Hi, I have a scenario to read from an existing table and transform each row (each row is a JSON and I need to flatten it based on some business...

Can't get columns from a table into a grid variable

I'd like to be able to load the column names from a table into a grid component to them use them in a python script. I have created a grid...

Grid variables

I am calculating pearson's correlation coefficient in python script,in function continuously for no.of values in input arrays,and pushed/appended this correlation to another array. now i have to send/append/push/update this array...