Orchestration Components

Mailchimp Query

Mailchimp Query This component uses the Mailchimp API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then use transformations to...

Delete Tables

Delete Tables Component This component allows you to delete a list of tables in a single operation. Note that the Delete Component has more in common with the Snowflake DROP TABLE statement...

S3 Get Object

S3 Get Object Note: This feature is only available for instances hosted on AWS. Transfer a file from Amazon S3 to a remote host. This component can use a number of common...

Storage Load Generator

Overview S3 Load Generator is a tool that helps users load delimited data from public objects in an S3 Bucket (Amazon Simple Storage Service). Cloud Storage Load Generator is a tool that...

Cassandra Query

Cassandra Query This component retrieves data on a Cassandra server and loads it into a table. This stages the data, so the table is reloaded each time. You may then use transformations to enrich...

Couchbase Query

Couchbase Query This component retrieves data on a Couchbase server and loads it into a table. This stages the data, so the table is reloaded each time. You may then use transformations...

Youtube Query

YouTube Query This component integrates with the 'YouTube Data API' (https://developers.google.com/youtube/v3/docs/) to retrieve data from YouTube and load it into a table. Warning: This component is destructive as it truncates or recreates its target table...

Alter Warehouse Component

Alter Warehouse Component The Alter Warehouse Component allows users to edit a warehouse from within Matillion ETL for Snowflake. This component makes use of Snowflake's Alter Warehouse functionality. Properties Property Setting Description...

Create File Format Component

Create File Format Component Creates a named file format that can be used for bulk loading data into (and unloading data out of) Snowflake tables. This format can then be used in...

JIRA Query

Jira Query This component uses the JIRA API to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then use...