Orchestration Components

Python script for emailing not working

Hello, I have written a python 3 script that send an email using a SMTP from my company. The script is working fine in my laptop running on python 3...

Python script for emailing not working

Hello, I have written a python 3 script that send an email using a SMTP from my company. The script is working fine in my laptop running on python 3...

Use variable in Database Query

Hi, Is it possible to call an environment variable in a database query object? I have tried with ${my-variable} but it fails. I want to dynamically filter on a timestamp...

Loading XML data

Hi What is the easiest way to load XML file data using Matillion? Thanks

mongodb query component - target field length

Hi, I am using mongodb query component to load data into redshift and wondering if there is any way to set field length on target table in redshift ? In...

X11 Display Variable Error - Database Query Component

I have a simple orchestration with Start and Database Query components. All connectivity from my AS400 to Redshift is intact and checks out ok. Query Component runs a simple "select...

What are the native types used by Matillion when creating a table?

What are the native Redshift types used when Matillion creates a table? The documentation for the component links to the Redshift documentation for each type but there are several potential...

Database Query - After data loading, DateTime fields in RedShift and source tables, are not matching

Hi, I'm using Database Query component to load a MySQL database into a Red-Shift schema. I noticed 5.5 hours (0530) difference in Date-Time fields, when comparing the source data and...

Add zstd compression support

Can you please add zstd compression support for Create table component?

Export stl_loaderrors to variable

Hi. We are using slack to deliver status messages from matillion. We have a source that can be somewhat unrealiable and we get a loaderror from redshift sometimes. In order...