Transformation Components

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

Transpose Columns Component

I am transposing a wide table, approx 300 columns. I use text mode (a great feature) to add the columns and upon validation I get the following error message: org.postgresql.util.PSQLException:...

regex_substring

I have this in a calculation component: REPLACE ( REGEXP_SUBSTR ( "system_info", 'Hostname: pixhd[0-9]{1,4}/i' ), 'Hostname: ', '' ) How do I make that regex case insensitive? Any help is...

Bad int64 value:

Any common reason for a "Bad int64 value:" error? In my table update component I changed every input to blank in the mapping and still get this error.. not sure...