Transformation Components

Data masking in CDC

Hi Team, I have a CDC configured with Oracle RDS as source and Snowflakes as destination, Please share the better approach to perform Data Masking of few sensitive data columns...

Mix ANDs and ORs in a "Filter component"

Hello, Is possible to mix "combine conditions" (ANDs and ORs) in a "Filter component"? It can have multiple conditions joined by ANDs or ORs but it does not except filters...

Export Table Name for Audit logs

Hi Team, Am trying to build an audit table with the environment variables, run time information of the components as a column, also we need to export the table name...

S3 Integration

Hello, I am wondering if I am able to run etl on data in located in s3 buckets. Currently, its my understanding that I can use Matillion to load data...

Calling functions & Procedures

Our current data base is Oracle and all the batches are developed in PLSQL. Now we are moving to Azure and Matillion as ETL and db as snowflake. Can we...

header

need the headers from the UNLOAD component to be in upper and lower case

How to pass variable in where clause in sql query?

I am using "Query Result to Grid" transformation component and using Advanced mode. I am trying to use a sql query which is similar to this: select customer_id from customer...

merging tables in snowflake

Our use case: 1. Create a copy of all the tables in staging schema(basically cloning tables from production). 2. Compare the cloned tables with the new tables(From source) a. if...

netsuite 2 factor auth

I am testing Matillion against netsuite but get a 2 factor authentication error. The Netsuite support team say they have disabled 2 factor. Another developer has switched to using Del...

S3 unload - filename

Hi, Is there a way to freeze/lock the filename in S3? S3 rename the file depending on node this was unloded from. I want a file with a name like...