Transformation Components

Row counts fail

I have a simple, inner-join that matches an int to another int. The int in the main table may be null. The int in the join table will never be...

DynamoDB

Have noticed this component is available for Redshift version of Matillion - is it / can it be made available for Matillion for Snowflake?

Executing transformation components sequentially

Dear Team, I have created a flow from Table input to one Table Update and one Table Delete Rows components, and I am using replicate component to share the data...

Transform list values to rows

Hello, this is my input table: ID value_list 1 "value_1,value_2,value_3" 2 "value_1,value_4" 3 "value_2,value_4,value_5,value_6" and this is the result I need: ID value 1 value_1 1 value_2 1 value_3 2...

S3 Load - Target Table Name

New User. Just doing a basic S3 load via generator. the drop drop for table name is always invalid and the job will not validate. why causes this disconnect between...

Transformation job takes way longer when run on its own

I've noticed I have one job, TransformationJobX, where when I run it as part of a scheduled job that also runs many other jobs, it consistently takes about 3-4 minutes...

SQL component

Is it possible to pass a column as a variable within a query such as: select row_number() over (partition by ${columnvariable} order by 1,* from ${tablevariable}? Regards,

Remove duplicates before storing into staging tables

Hi, Is it possible to, remove duplicates based on few columns( ie: when the column has a null or empty value should be removed) before storing it into the staging...

Task Log in e-mail in Mtaillion for Bigquery

I need to set up e-mail notifications for job status and message in Matillion for Bigquery. Is there any example or tutorial for this?

Segment Data Component

Is there a component which can split/segment a data set into two more datasets. e..g I have a list of cars and want to split it into petrol and diesel...