Orchestration Components

Delete Partition

Delete Partition Allows users to delete the S3 directory structure created for partitioned external table data. On S3, a single folder is created for each partition value and is named according to...

Stripe Query Component

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

ServiceNow Query Component

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

YouTube Analytics Query Component

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

DynamoDB Data Model

Connection String Options Access Key Auto Cache Auto Detect Index Batch Size Cache Connection Cache Driver Cache Location Cache Metadata Cache Query Result Connection Life Time Connect On Open Domain Firewall Password...

Square Query Component

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

QuickBooks Online Query

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

Google Custom Search Query

Google Custom Search Query This component uses the Google Custom Search API to retrieve data from a Custom Search Engine (CSE) and load it into a table. This stages the data, so...

Gmail Query

This component retrieves Gmail Inbox data and loads it into a table. This stages the data, so the table is reloaded each time. You may then use transformations to enrich and manage...

Copy Table To External Schema

Copy Table To External The Copy Table to External Schema tool is available through the Components menu in any Transformation job. This tool facilitates any table to be written as an external...