> ## Documentation Index
> Fetch the complete documentation index at: https://docs.maia.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Transformation overview

Transformation components are used in **transformation pipelines**, which transform table data that already exists in your data warehouse—typically loaded there by an orchestration pipeline.

These components are often analogs of SQL operations, allowing you to filter, join, aggregate, and reshape data without writing raw SQL.

***

## Common components

* [Table Input](/docs/components/table-input)—reads data from an existing warehouse table into the pipeline.
* [Filter](/docs/components/filter)—keeps only rows matching defined criteria.
* [Aggregate](/docs/components/aggregate)—groups and summarizes data, for example summing a column per group.
* [Rank](/docs/components/rank)—ranks rows within partitions based on ordering criteria.
* [Rewrite Table](/docs/components/rewrite-table)—writes the transformed data permanently to a new or existing table.

AI components let you apply large language models to your warehouse data directly within a transformation pipeline:

* **Snowflake Cortex**—a family of components including [Cortex Completions](/docs/components/cortex-completions), [Cortex Sentiment](/docs/components/cortex-sentiment), [Cortex Summarize](/docs/components/cortex-summarize), [Cortex Translate](/docs/components/cortex-translate), and more. Snowflake only.
* **Databricks AI**—a family of components including [Databricks AI Query](/docs/components/databricks-ai-query), [Databricks AI Classify](/docs/components/databricks-ai-classify), [Databricks AI Summarize](/docs/components/databricks-ai-summarize), [Databricks AI Translate](/docs/components/databricks-ai-translate), and more. Databricks only.

<Note>
  Each component is exclusively applicable to one pipeline type—orchestration or transformation—and cannot be added to the other. To embed a transformation pipeline within an orchestration pipeline, use the [Run Transformation](/docs/components/run-transformation) component.
</Note>