Orchestration Components

Delete and create new Orchestration Job used in a schedule

Hi, If we delete an Orchestration Job and create a new one (or import one) with exactly the same name, all the schedules using that Job become erroneous. We need...

Concurrent jobs with BEGIN component

I am processing dimensions with the SCD logic proposed by Matillion (uses multiple update statements in a single job - one for updates to Type 1, one for Row Expiry...

Load Generator

I have a file sent from an external source that contains extra line feeds at the end of the file. When I look at the documentation for the load generator...

Passing variables to a SQL Script component in Orchestraton job

Hello, I'm passing a mix of both environment and job variables into a SQL Script component in an orchestration job. The variables are defined as numeric, text and datetime datatypes,...

Dynamically select all columns in Salesforce Query

I am building a job that extracts data from multiple salesforce objects into snowflake. Here is our process: 1. use Query Result to Grid to pull list of sfdc objects...

How to view the value added to grid variable

Hello, I'm pretty new with Matillion. How do I easily view the values loaded into the Grid Variables? Is there any best practices to do so? Thanks for your help!...

Loading jsonb data from Postgres to Snowflake

Hi we've got data in an Amazon Aurora Postgres database, with a substantial amount of data in "jsonb" type columns. We want to load this across into variant type columns...

API to launch a job from python

I want to kick of my loads via a python script.

S3 unload

I need to upload some files to AWS in txt format pipe delimited from S3 Snowflake. The files load but it seems like its loading columns and rows in sequential...

query result to grid

After querying a result to grid how do you select from the grid variable and insert into a table? Please type sample syntax. Thanks,