Advanced

Task log in an e-mail

We have a Matillion job with multiple orchestration and transformation components. We have setup SNS component to send out notification of failure of specific orchestration component. However it lacks details...

do you have any component in matillion could send an email when a job running failure?

do you have any component in Matillion could send an email when a job running failure?

Query compilation failed

Dear support team, When I am trying to select data by the following way, there was an error happened. But when I deleted the code marked red, it worked well....

can't review "Task History" records ?

I can't review "Task History" records. it was taking forever for "Fetching records ....". Can you please check it ?

Download data from S3 in another Account

Is it possible to download files from another companies s3 account using the aws key and secret?

multiple environments

We currently have two instances of Matillion running: one in a staging environment and one in a production environment. The setup should be identical except configuration such as database connections...

Ad-hoc queries

Hi. When using Redshift its required in my office to deploy redshift in a private subnet. This raises some issues with making ad-hoc queries against the cluster. In order to...

Transfer the data from source redshfit DB to another redshfit DB.

I want to transfer the data from source redshfit DB to another redshfit DB. would you please let me know how to do it in Matillion ? Those 2 redshfit...

Recommended method to create surrogate keys

Hello, Is there a recommended way to create surrogate keys that increment by 1 on a multi-node redshift cluster? I've tried the identity column but it does not seem to...

how to pass Matillion's "Environment Variables" to python application

Pass Matillion's "Environment Variables" to my python application which is run in Bash Script Component ? for example I have this command shell command ("python test.py") in Bash Script Component....