Transformation Components

control frame work for jobs monitoring running long times

Hi I am looking for control frame work if any jobs runs more than a threshold time set up sending alert.would be able to provide any document ? Currently I...

Join Component - Avoid Losing "Join Expressions" when Table Aliases Change?

With a Join component, it seems that if I change the "Join Alias" of a table, then its "Join Expression" automatically gets deleted. Or, if I change the "Main Table...

Updates from Multiple Delta Input Files

I get daily delta files (includes only records with changes) from a production system. I need to update a Redshift table with these deltas. I specifically need to update them...

Metadata field in the s3load component

I don't see Metadata field in s3 Load component for snowflake as it is mentioned here in this document: https://snowflakesupport.matillion.com/customer/portal/articles/2042349-s3-load Am I missing something?

SQL Cross-join

I'm looking to execute a cross-join of a reference table to a master table, but realized there is no cross-join option within the join component. What is the best way...

connect to hana views and load the data using Matillion

Is it possible o connect to hana views and load the data into Target which is AWS data lake, using Matillion?

Begin/Commit/Rollback

Hello, one question regarding the usage of Begin/Commit/Rollback Components: Are there any restrictions or limitations regarding the usage of Begin/Commit/Rollback? I think about limitations regarding runtime of a job that...

Iterators

Hello. I have a table with a single column: ID It's the IDs of every file that has changed. I'm iterating through another table for additional information about each file...

RDS Update component

Hi, Is there any way we can update particular records in the RDS source? We are planning to track deleted records in a separate table in source and once these...

Issuses with Calculations in API Queries

A bunch of seemingly similar issues... 1. I'm looking at https://redshiftsupport.matillion.com/customer/portal/articles/2895383?b_id=8915 The month() function is missing here. It works for me just fine. 2. The dateformat parameter to the dateadd...