Skip to main content
Analyze Tables is an orchestration component that 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 Redshift ANALYZE command that rebuilds statistical metadata for a given table and allows for more optimized queries. You may wish to do this after modifying some tables earlier in the orchestration flow that had existing data in them, but the changes may have modified the table statistics considerably, and you wish to analyze the data distribution to optimize queries on those tables.
  • Analyze is often not required at all when a table is truncated and reloaded, which is preferred to DML updates.
  • External tables cannot be analyzed.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Schema
drop-down
required
Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.
​
Tables to Analyze
dual listbox
required
The tables to analyze.