Orchestration Components

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

S3 put object

Hi , I am new to Matillion, I am trying to download the sample data from http:/data.dft.gov.uk/road-accidents-safety-data/RoadSafetyData_Vehicles_2015.zip put into s3 bucket. I am getting the following error message "protocol =...

Increasing S3 Load Columns Limit

Hi all, I was using the S3 Load Generator Components on a S3 gzipped CSV when this error occurs: Exception caught whilst getting sample: java.lang.ArrayIndexOutOfBoundsException - 512 Hint: Number of...