> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://docs.mammoth.io/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Advanced patterns

> Architecture patterns for complex, high-volume or multi-team Mammoth projects, including governance, validation, incremental processing, AI and API workflows.

These guides are for data engineers, architects, and administrators. They cover architecture decisions for complex, high-volume, or multi-team Mammoth implementations, and assume you are comfortable with core Mammoth functionality.

## Advanced guides and when to use them

| Guide | What it covers |
| --- | --- |
| [Enterprise architecture](https://docs.mammoth.io/guides/advanced/enterprise-patterns) | Multi-team deployments, governance, roles at scale, workspace organization |
| [Data validation](https://docs.mammoth.io/guides/advanced/validation) | Quality gates, reconciliation checks, audit-ready pipeline design |
| [Incremental processing](https://docs.mammoth.io/guides/advanced/incremental) | Large datasets, performance optimization, change data capture patterns |
| [Multi-source joins](https://docs.mammoth.io/guides/advanced/multi-source) | Joining datasets with mismatched keys, fuzzy matching, entity resolution |
| [Custom transforms](https://docs.mammoth.io/guides/advanced/custom-transforms) | Complex logic that standard tasks cannot express, using chaining, Generative AI, and AI SQL Query |
| [Dataset workflows](https://docs.mammoth.io/guides/advanced/dataset-workflows) | Dataset versioning, branching, promotion from development to production |
| [AI-powered workflows](https://docs.mammoth.io/guides/advanced/ai-powered-workflow/) | Choosing between Generative AI, AI SQL Query, Bulk Replace and the AI Prompt bar, and running them in production |
| [API workflows](https://docs.mammoth.io/guides/advanced/api-workflows) | Triggering Mammoth automations through the API, polling for completion, pushing results out |
| [Pull data from a REST API](https://docs.mammoth.io/guides/advanced/rest-api-import) | Connecting a REST or Elasticsearch source with the CLI, sampling it, creating a dataset and refreshing it on a schedule |

---

> Warning: Advanced content\
> These guides assume proficiency with Mammoth's core features. If you are new to Mammoth, start with the [use case guides](https://docs.mammoth.io/guides/use-cases/) before the advanced patterns.

---
Source: https://docs.mammoth.io/guides/advanced.md · Updated: 2026-10-13