Orchestration Components

JIRA Query API Token Required

The JIRA Query seems to have changed in the lastest update. Instead of allowing either username/password or username/api token it is not only accepting API tokens. Am I doing something...

Salesforce Incremental Tool

What is the watermark column used by the Salesforce Incremental Tool?

Database Query component connect to different servers based on environment

Using the "Database Query" component, it's possible to use a variable for "Password" property, but it's not possible for "Connection URL" and "Username". I want to connect to different database...

Query- Live data Replication - Approach

Hi Team, I have two queries with respect to live data replication. Please share the better approach to achieve the same. Case 1. Source: RDS to Destination:Snowflake via Matillion. Case...

Azure blob csv file New line character

Hi Team, I am facing the issue with loading data from Azure blob storage to Snowfalke database. In csv file i am getting New Line Character. How to handle it...

Python Scripts for custom transformations

Hello, I am interested in implementing custom transformations in matillion. My current understanding is that the only way to implement custom code is through the python/bash script orchestration components. My...

not able to access azure blob

I couldn't able to view the csv files in Matillion which are placed in azure blob. Upto folder level I am able to access. Using identity access method and granted...

Environnement variable

I use a Python script get a datetime in Snowflake then i convert it in a format to be able to put this variable when i call the API (...

Move files between folder in SFTP Server using Bash Script.

Hello, I would like to move files from one folder to another in the SFTP server using the Bash Script component. Can anyone help me with that? Thank you

odata query component w/o id and etag

is there a way to have the component NOT pre-pend "id" and "etag" columns to the data/table that's created by the component? My OData source doesn't support these, and as...