Transformation Components

Disk Full Errors

Hello, I am getting Disk Full Errors on some larger running Orchestrations. I see plenty of suggestions when searching for Redshift Disk Errors but I'm not finding much relative to...

Table Update in matillion etl for snowflake

i'm little bit confused about table update component.can anyone let me know how to update data using update component in matillion etl for snowflake?

How to increase max size of s3 json import

Trying to import json file from s3 Error parsing JSON: document is too large, max size 16777216 bytes How to increase the size, my documents are approximately 50 MB.

Regex

I have a string: blahblahblah(user_id:1234)blahblah5678 I can't figure out how to format my Regex to all just the integer out of the parenthesis. I need to avoid the digits outside...

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?