Orchestration Components

Parameter Validation Failure: SQL Query - Timeout.

Parameter Validation Failure: SQL Query - Timeout. I have setup variables on table name so i can run through all my bigquery google analytics tables: `139139762.ga_sessions_20180705` `139139762.ga_sessions_20180704` `139139762.ga_sessions_20180703` I am...

BigQuery to Redshift How Many Rows Can I Pull

Trying to pull our bigquery google analytics data into redshift. It doesn't look like there is an option to load daily files since it deletes table and reloads every time....

Bigquery Unnest

Trying to build a bigquery into redshift query and it works in bigquery, but when I try and load it to matillion I am getting the error: No table found...

Bash Script component

I am trying to use the bash script component (in conjunction with a file iterator) to move a file from one directory of an sftp site to another. Is there...

Accessing the New SQL Editor in v1.33?

The version 1.33 release notes say: "SQL Editor (in all Query components) now shows available Tables/Columns and Variables to help you author and test SQL queries from source systems." I...

Salesforec Query Error

I am trying to use username/password/security token to connect. But still getting a Timeout error. I have listed Matillion IP as trusted IP in SFDC portal too. Please suggest.

ServiceNow query

From which version , can we use the ServiceNow query component in orchestration components ? Our version: Version: 1.28.7 (build 36) AMI Version: 1.28.7

Delete S3 Objects

How do I go about deleting an S3 object? I want to copy an object from inbox into archive and then delete it from inbox. The S3 Put Object component...

MongoDB query component advanced connection options

Hello, I am trying to connect to a Mongo cluster in Atlas. How do I specify advanced connection options e.g. authentication database or use ssl? These options don't seem to...

RDS Query component no long works in Version: 1.25.3 (build 66)

I get this error when I try to pull data from RDS "Exception during component validation: null" How do I fix?