Analyze Tables
- DarkLight
Analyze Tables
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
This article is specific to the following platforms - Redshift.
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 Redshift ANALYZE statement 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 in order 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.
Note: External tables cannot be analyzed.
Properties
| Property | Setting | Description |
|---|---|---|
| Name | String | A human-readable name for the component. |
| Schema | Select | Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, see this article. |
| Tables to Analyze | Select | One or more tables to Analyze. |
Strategy
Generates a single ANALYZE statement, listing the chosen tables.