Analyze Tables
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.
Note
- 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
A human-readable name for the component.
Schema = drop-down
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.
Tables to Analyze = dual listbox
The tables to analyze.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ❌ | ❌ | ✅ |