Getting Started

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

UI

How do I disconnect components?

Elastic Load Balancing

Hi. Do you have a set-up guide for using Elastic Load Balancing? Regards. Johan Forssell

ssh tunnel to Matillion

When Matillion is deployed in a secure network, developers will need to access the service via a bastion, such as a Windows host using RDP. That can get pretty annoying,...

Refererring to an S3 bucket by a variable

I have been using the S3 load component and trying to load an S3 bucket referred to by a variable - i.e. putting a ${BUCKET_NAME} in the bucket source field...

Dynamic default variable value for DateTime data types

Hi, is it possible to declare a dynamic default variable value for the DateTime data format - e.g. now()? If we leave the default value empty and reading that empty...

Create and delete variable with python

Hi. Is it possible to use the python component to create and delete variables?