Getting Started

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?

Changing from port 80 to 443 on server

Our current VPC rejects port 80 internally and I cannot even get to the website to change to 443 due to this issue. Are there instructions on how to change...

Viewing Error Logs

I'm new to Matillion and have been looking into some error messages that AWS has notified us of in our Matillion instance. Each time our ETL process begins, it fails...

Accessing S3 Bucket

I'm not able to view or access any S3 buckets from within matillion. I've ssh'ed to the server using ec2-user and I can access and list the buckets using the...

Doing Data Quality Checks

We're going to be loading a large number of files from different data sources and would like to do some checks on S3 files before they're loaded into Redshift. Among...

cursor.execute creates Phython exception

I try to realize the following idea: https://redshiftsupport.matillion.com/customer/portal/questions/16653780-using-value-from-redshift-as-variable-to-a-bash-script?b_id=8915 The script cursor = context.cursor() cursor.execute(‘SELECT count(*) FROM tdc.dim_test’) result = cursor.fetchone() print result runs into "Exception: Cannot create PyString with non-byte...