Advanced

Block users from creating projects

Hi. Is it possible to block users from creating projects?

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