Orchestration Components

Begin Component

Begin Component Note: This feature is only available for instances hosted on AWS. Warning: Rollback in Snowflake affects only DML statements but not DDL statements. This means, for example, a Rollback can...

Commit Component

Commit Component Note: This feature is only available for instances hosted on AWS. Warning: Rollback in Snowflake affects only DML statements but not DDL statements. This means, for example, a Rollback can...

Rollback Component

Rollback Component Note: This feature is only available for instances hosted on AWS. Warning: Rollback in Snowflake affects only DML statements but not DDL statements. This means, for example, a Rollback can...

Salesforce Query

Salesforce Query This component uses the Salesforce 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...

LDAP Query Component

LDAP Query This component connects to an LDAP server to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then...

MongoDB Query Component

MongoDB Query This component connects to a MongoDB server to retrieve data and load it into a table. This stages the data, so the table is reloaded each time. You may then...

DynamoDB Load Component

DynamoDB Load Component Load data into an existing table from objects stored in Amazon DynamoDB. This uses an inate ability of DynamoDB to push to Redshift, unlike the similar DynamoDB Query component...

Dynamics CRM Query

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

NetSuite Query Component

NetSuite Query This component uses the NetSuite 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...

Google BigQuery Component

Google BigQuery This component uses the Google BigQuery API to retrieve data and load it into a Redshift table. This stages the data, so the table is reloaded each time. You may...