Advanced

Manage SQS Configuration

We have an NRT job kicking off using a Lambda and SQS whenever a trigger file is dropped in a certain bucket. We have seen that during Redshift maintenance window...

Pass a table to python script and create another table

I have a table in which a column is a php serialized object. I want to de-serialize the column and make another temporary table with the deserialized values. for example:...

Central variable repository

Hi. We are using matillion in three different instances (prod, qa, dev). We are exploring the possiblity to to store variables in a centraly managed database to be used by...

LDAP Authentication: userBase

When configuring LDAP authentication, if I set my 'userBase' value to "dc=domain,dc=com" the authentication files. If I set it to "ou=Unit,dc=domain,dc=com" it works. Unfortunately, some of the users will be...

rolling 24 months

Community...I need to put a filter on my Table Input component to read only the last 24 months. I've tried using variables and something like: ${dt.now().add("months", -24)} but it's not...

Redshift is transitioning to ACM Certificates

We just got this notification from Amazon, about our Redshift cluster: https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-transitioning-to-acm-certs.html Does this affect how Matillion works with Redshift? Will I have to do anything?

Database Query Component Mapping

I'm using a Db Query Component to stage data from a SQL Server source. I've noticed that source tables with BIT column are mapped to a VARCHAR(5) column. Is there...

Chnage color-theme

Hi. We are running Matillion on three different instances (Prod, QA and DEV). Is it possible to differentiate the instances by color in the interface or something else? At the...

Matillion Deployment using API

What are other people doing for deployment of ETL code from one server to the next? We are currently using the Matillion API and migrate from Dev to Test to...

Matillion API

We are using the Matillion API to migrate projects from Dev to Test to Prod. Is there any way to include the credentials for a project when it is imported...