Transformation Components

Cannot find Is_Json_Valid function in Calculator Component

Hi, I am unable to find the IS_VALID_JSON function ( https://docs.aws.amazon.com/redshift/latest/dg/IS_VALID_JSON.html ) in the Calculator Component of Matillion for Redshift. Where can I find this function?

Cassandra Data Query

Hello, I have a Cassandra whereby it is running on 6 nodes. Is there any configuration option in Cassandra component whereby to point the extraction to a specific node. Regards...

Adding timestamp to loaded records

Hi, what is the best way to add a timestamp to a target table? I am using Table Output Component but in the Column Mappings I can only select input...

detect changes

Every time i validate the detect change component , an invalid identifier error pops up. How to fix this error

Update all table in one transformation job

Is it possible to perform table update transformation job on all tables from on schema to another.

Add Leading zeros in record

Hi, I have a transformation which loads data one to one from a view to a target. Now I have a column varchar(5). I want add leading zeros whenever record...

Add Leading zeros in record

Hi, I have a transformation which loads data one to one from a view to a target. Now I have a column varchar(5). I want add leading zeros whenever record...

Update query in SQL component

I'm trying to put an update query in a SQL component. Is that not supported? Even with very simple updates, the component won't validate, giving me an error: "Validation error....

Table Update component not inserting records

Hi Team, I am using Table Update component to insert my target table record, same transformation is working for other jobs without putting BEGIN/COMMIT component but for one orchestration job...

Filter on Boolean Data with Filter Component

I have extracted data from a SQL Server table, including a "Bit"-type column. Now, in Matillion, when I use a Table Input component to use that raw data, I have...