Orchestration Components

JDBC connection

i m using JDBC Load Component in Matillion ETL For Snowflake...Please help.... I m getting the following error while i connect .... Exception caught whilst testing connection: No suitable driver...

Tables load

Using database query component i can fetch only single table ,if I wanted to load all the tables belongs to a database from sql server to s3 bucket using matillion...

python component to trigger parallel job

Hi team, I have to trigger multiple workflow in a gap of 15-20 minute , I thought of using python script for calling workflow , I believe Matilllion has their...

Data migration from Teradata to Redshift using Database query component taking long time

Hi Team, I am migrating Terdata table Data (approx 200 million records) to Redshift using Database query component , I have setup 17 currency as I am on Cluster ds2.xlarge...

Data migration from Teradata to Redshift using Database query component taking long time

Hi Team, I am migrating Terdata table Data (approx 200 million records) to Redshift using Database query component , I have setup 17 currency as I am on Cluster ds2.xlarge...

Getting Filename from a S3 bucket and assigning into variable

I am trying to get the file name that resides in a S3 bucket. The filename varies every day in the S3 bucket. I need this to be assigned to...

Variable in SQL insert statement

I defined a variable with 'FileName' and assigned a value to it. No I am trying to use this variable in the INSERT INTO statement. cursor.execute("INSERT INTO etlbatch (source) VALUES...

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