Orchestration Components

Netsuite component

In Netsuite there are three type of browsers 1. Schema Browser 2. Records Browser 3. Connect Browser http://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/schema/record/account.html Matiilion is displaying on tables that are available in Schema Browser but...

Overwrite Default Value in Variable

Basically I have a LOAD_DATE variable, that holds the load date of the current run. At the beginning of my outer job I select the latest LOAD_DATE from a SQL...

assign a value from snowflake table to a variable

Hi, there. After declaring a variable, I would like to assign a value from a snowflake query to this variable. Is there a way to do this in matillion? Thanks....

Multiple SQL Statements in SQL Script

Hi I want to run a SQL Deploy Script that has 1000 DDL statements inside it. When I pasted it into SQL Script and execute I get the following error:...

Ignoring Footers

A few of my clients send footer lines. You don't have an option to skip the last line. I've set skip file when n errors set to 2. What I'd...

case sensitive columns

The create table in Snowflake surrounds all columns with double quotes. This makes the column names in the database create as lower case. However Snowflake defaults everything to upper case....

S3 Load generator - Snowflake

I noticed you don't have the S3 Load generator for Snowflake. Do you have plans to add this?