Transformation Components

Flatten Variant component

I am not able to find the Flatten Variant component in component list. I am using 1.35 version.

Extract text and value

I have a column X with multiple strings and corresponding values eg {text1.23,text2.44,text3,55etc} . I want to spilt that column and make multiple columns as text1, text2 , text 3...

Hashing with SHA-256

Have a need to hash some information using SHA-256 as part of a transformation. I assume there are ways to plug this in via Python, but I don't see any...

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,