Orchestration Components

Snowflake Schema to Schema Data Load

Hi, I have two schemas in Snowflake: PUBLIC, TARGET I need to copy data for all the tables in PUBLIC schema to TARGET schema I could use Schema Copy, but...

Reading column names from a .csv file

Hi, I'm wondering if there's a recommended method for reading the column names from a file (.csv for instance) and creating a table out of that metadata. I see the...

JDBC connection

In JDBC Incremental Load first time when i load yes no are the options one column for each table i m using yes to load all the tables.. while loading...

Bing Ads Query

Trying to query bing ads using the new Bing Ads Query component. I can't seem to get any pre 2019 data

SSAS connetion component

Hello, Can matillion create a SSAS (Microsoft SQL Server Analysis Services) connection and extract data from a SSAS cube? (I did a search on data connections and in the release...

File Iterator not copying data

I'm trying to figure why the file iterator component is not copying around the data I have in the csv files I'm copying from one S3, bucket to another. It...

File Iterator Component

How to setup File Iterator Component Input Data URL from Jython script? Thank you, Dmitriy Burtsev

Tables load

Can I use table iterate to load more than one table in s3 staging Using matillion etl for snowflake

Tables load

Matillion etl for snowflake is my environment... I want to load tables data from sql server to s3 in parquet file format... If it's possible to load ,which component will...

Use Matillion for some DBA tasks

Hi, I am using Matillion for Redshift to ETL from MySQL to Redshift, but I also want to use Matillion to do some of my DBA tasks in MySQL, but...