Transformation Components

Calculation Fields

I have a field in a table that contains strings. I have another field in the same table that is boolean. I'm trying to figure out how to set the...

Do not update data if key exists

I need to lookup a key and insert record if it does not exist. The record should not be updated if the key exists. Is there a component I can...

How to Accept 0000-00-00 Dates

Hello - I have a simple truncate and reload process for a table. However, in my first step (using a database query)....the job will break if ANY of the fields...

Need to delete rendundant rows from redshift

Hi I am replicating rds mysql database tables on to redshift. everything is working fine. Even updated rows I am able to track using last_updated_time stamp and modifiying in redshift...

Dynamically Union Tables Together

The Scenario: I'm creating a job that is intended to be iterated through for a number of source tables....so ONE job that can be run over and over again and...

Loading data from Redshift into RDS (SQL Server)

We have a scenario where some data needs to be transferred out of Redshift and loaded into a SQL Server RDS instance. Is there a Transformation to do this?

Loading data from Redshift into RDS (SQL Server)

We have a scenario where some data needs to be transferred out of Redshift and loaded into a SQL Server RDS instance. Is there a Transformation to do this?

Conditionally Creating a New Table

I have a job that compares a master table with a stage table every day, compares changes, and then does an incremental load of any new or changed records. This...

Late binding views

Now that Redshift supports late binding for views (no schema validation until runtime), how can I use these as inputs in Matillion? Using a Table Input component I can select...

Efficient Transformation

Hello, I have a large table (let's call it customer) with many column attributes in the table. Some of my data (say some customers) has been updated and have been...