Analyze Tables

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 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.

Note

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.

---

Strategy

Generates a single ANALYZE statement, listing the chosen tables.

---

Snowflake	Delta Lake on Databricks	Amazon Redshift	Google BigQuery	Azure Synapse Analytics
❌	❌	✅	❌	❌