Getting Started

Redshift Spectrum - Availability

Hi, I presume the use of Spectrum features rolled out with Matillion version 1.28.7 is, at the time of writing, limited to users with Redshift/S3 buckets established in selected US...

S3 bucket

I have abc_trigger_ddd_dfffd.txt like files in my s3bucket. I wan t to get count of files have _trigger_ word in bucket using python Thanks in Advance

What do the red triangles mean?

In some contexts, like when setting the values of Environment Variables...or setting the Output Columns of a Join component...red triangles appear in the top-right corners of some of the fields...

Browser gives warning: "Changes you made may not be saved."

I am using Matillion in Chrome. Whenever I attempt to navigate away from the Matillion web app, or close the browser tab, a Chrome pop-up says: "Do you want to...

Instance Limits

Hi Just wondered what the performance difference between the throttled instance of Matillion with 4 threads and non throttled instance of 4 threads. How much throttling is applied? Thanks Hamish...

Can environment variable values of one job interfere with another

We have a development/test (Default) version and locked production version of our orchestration job, both in the same project. They both contain one environment with the same environment variables. I...

How to lock versions and manage locks?

We're planning to protect our latest productive version with version locks. The support article Version Control, subsection Managing a Version describes the steps to lock existing versions. However, we don't...

Sending Email using Python script

Hi Team , I am looking to send the Email notification at the end of ETL , if success I want to send Success Email else Error Email notification. Plesae...

Creating API profile with OAuth

Hi, In this guide, reference here: https://redshiftsupport.matillion.com/customer/portal/articles/2312291-setting-up-oauth-in-matillion-etl-for-redshift It says only some certain APIs are supported OAuth. Is it possible to configure OAuth in any other custom API profile? Is there...

Matillion API unauthorized response JSON

Hi, Recently I started working on Matillion API and these are the main articles currently I'm referring to. 1) https://redshiftsupport.matillion.com/customer/en/portal/articles/2531801-matillion-etl-api-?b_id=8915 2)https://redshiftsupport.matillion.com/customer/en/portal/articles/2565073-api-examples?b_id=8915 I use this (http://onlinecurl.com/) online curl requests submitting tool...