Transformation Components

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

Filtering table using dynamic dates

Is it possible to filter a table in a transformation job using a dynamic date e.g. -2days ago from the runtime? I have tried putting "${dt.now().add("days", -2)}" into the value...

Date round in mongo db query component

I have a date field in utc format like '2017-06-02 16:39:35.843' how to round the date '2017-06-02 16:39:36' in mongodb query component advanced mode?

Use Grid column with an expression

Hello, I would like to understand if it is possible to apply an expression to a Grid column value when mapping it to a component property, similarly to applying a...

S3 to Redshift

Hi, I need to ignore few columns before loading data from S3 onto Redshift. How can I achieve this using Matillion?

Unable to rename columns using rename component

I am trying rename columns using rename component, but after running the job, the below message is displayed " Metadata Update Skipped" and I am unable to see the renamed...

File Movement in Google Bucket

Hi Team, I need to move file from one folder to other in Google Bucket. Which component i can use for this or any help on steps would help.

Duplicate key error with Table input

I have an Orchestration which creates this table: CREATE TABLE public.mt_documents ( activityid varchar(2000), displayname varchar(2000), endtime timestamp, groupid varchar(2000), starttime timestamp, "user" varchar(2000), devicename varchar(2000) ) Now, I want...