Advanced

Extract specific job through API

Can I extract specific job instead of the whole project through API ? Didn't find that in documentation. I've exported like this "curl -o Test.json -X GET -u <username>:<password> -H...

Disable Component

Hi. This is more of a development suggestion. When doing development it would be great to be able to disable components in a job. It is possible today to remove...

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