Orchestration Components

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

Component to create file on GS?

Hi! I want to Query SQL server table and store the results in csv format in GS. What component should I use? The Query Database component have a staging area...

Oracle CLOB field to Snowflake VARCHAR

I'm working on data transfer between two databases, one Oracle 12c and one Snowflake Data Warehouse. In the Oracle DB, there is a CLOB field which needs to be loaded...