Orchestration Components

Vacuum Tables Component

Vacuum Tables Component Perform a vacuum operation on a list of tables. Vacuum is a housekeeping task that physically reorganizes table data according to its sort-key, and reclaims space leftover from deleted...

Truncate Tables Component

Truncate Tables Component Truncate a list of tables. Truncate is implemented in two different ways, depending upon whether the current flow is in the middle of a database transaction. The first is...

Analyze Tables Component

Analyze Tables Component This component allows you to analyze a list of tables in a single operation. Entire tables are analyzed, not individual columns. 'Analyze' in this context refers to the Amazon...

SQL Script

SQL Script Component (Orchestration) Write your own custom SQL script. The script may contain multiple SQL statements, however since there is no way to recover the output of the script the statements...

SQS Message Component

SQS Message Component Note: This feature is only available for instances hosted on AWS. Post a message to an Amazon Simple Queue Service (SQS) queue. Other applications can read those messages and...

Schema Copy

Schema Copy Component Copy data from one or more tables from one schema to another. The source schema defaults to the one defined in the currently selected environment. Target tables can be...

Run Orchestration Component

Run Orchestration Component Run another orchestration job to completion. After the orchestration job completes, other orchestration components can be linked to this one depending upon success or fail. Use this component to...

Database Query Component

Database Query Run an SQL Query on an accessible database and copy the result to a table, via storage. This component is for data-staging - getting data into a table in order...

S3 Unload Component

S3 Unload Component Creates files on a specified S3 bucket, and loads them with data from a table or view. Note: This feature is only available for instances hosted on AWS. By...

S3 Put Object Component

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