Transformation Components

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

Dealing with Nulls

I have a component that outputs Latitude and Longitude as strings and I want to convert them to floats. I'm using a Convert Type component, but many of the source...

How to update variables from db values

We use one table as a parameter table, whose values affect subsequent processing. At present, I read the values in a Python script component and update the variables via the...