---
title: "Triage assets for migration - Atlan MCP Cookbook"
url: "https://atlan.com/mcp-cookbook/triage-assets-for-migration/"
description: "Classify every asset by consumer count, ownership, and certification before migrating."
---

> Atlan is hosting Context Conference, bringing together the leaders and builders at the frontier of giving AI the context it needs to understand their business. It runs online on October 28, 2026, from 11:00 AM to 2:00 PM ET. Atlan co-founder Prukalpa Sankar opens and closes the day. Leaders from AstraZeneca, BNY and Verizon share why they invest in context and what they get from it. Registrants get early access to The AI Context Gap, a new study from MIT Technology Review Insights. Register: https://atlan.com/context-conference/

Recipe 11 in [The Atlan MCP Cookbook](https://atlan.com/mcp-cookbook/). Classify every asset by consumer count, ownership, and certification before migrating.

Use case: Retire & migrate / Action: Make changes / Persona: Data Engineer / Effort: Involved / Runs in: any AI tool

Requires Atlan MCP connected to your AI tool: [set up Atlan MCP](https://docs.atlan.com/product/capabilities/atlan-ai/how-tos/remote-mcp-overview).

## 1. The task

**Scenario.** You are moving the legacy_dwh schema to a new warehouse, and the fastest way to stall is to migrate in the wrong order: a table you called low-priority turns out to feed forty dashboards, or has no owner to answer questions. You want every asset scored up front so you move the high-traffic, well-owned tables first.

The ask:
- All tables in the legacy_dwh schema
- Each one's downstream consumer count, owner, and certification
- A high, medium, or low migration priority written to custom metadata

Hero prompt: "We're migrating all tables in the legacy_dwh schema to the new warehouse. For each table, show me how many downstream consumers it has, who owns it, and whether it's certified. Then classify each one as high, medium, or low migration priority and write that to the Migration Priority custom metadata field."

Step by step:

1. Search for all assets in the source environment. Prompt: "List all tables in the [legacy_dwh] schema."
2. Check downstream consumers, owner, and certification. Prompt: "For each, trace its downstream consumers outward (expand as needed), and show its owner and certification status."
3. Score each by migration priority and write it to custom metadata. Prompt: "Classify each as high, medium, or low priority and write it to [Migration Priority] custom metadata."

## 2. What you'll give it

Required context:
- The source scope (legacy_dwh)
- The priority rubric (what makes a table high versus low)
- A Migration Priority custom metadata field, and permission to write it (if it doesn't exist yet, create it once first - a one-time setup step)

Optional context:
- A usage window for "active" consumers, so dormant dependencies do not inflate priority
- A cap, if you want only the top tier scored this round

## 3. What Atlan creates

Outputs:
- Every legacy_dwh table with its consumer count, owner, and certification
- A high, medium, or low priority per table, against your rubric
- The priority written to the Migration Priority custom metadata field

**Summary.** The migration gets a running order instead of a guess. Sort by the field, and the high-traffic, well-owned tables move first, with the orphans flagged before they surprise you.

**Writes to Atlan.** Changed: the Migration Priority custom metadata field on each table. Left untouched: the tables, their lineage, and the data, all read to compute priority, not edited.

## 4. Follow-up prompts

- **Give me the wave plan:** "Group the tables into three migration waves by priority and show the owner for each wave."
- **Surface the risks:** "List the high-priority tables that have no owner or are not certified; those need attention first."
- **Track progress:** "As tables get migrated, show what share of high-priority tables remain."

## 5. Tips & troubleshooting

**Cook's note.** Sort by consumer count. Migrate the high-traffic, well-owned tables first.

- Match the tool to the work. This scores a whole schema; use a more capable model so the rubric holds across every table, and review before it writes.
- Automate or chain it. Re-run it weekly through the migration, so the priority field reflects what is already moved and what remains.
- Ask what it changed. Add "list every table you wrote a priority to and the value." That is the record of the triage run.

## Related recipes

- [Safely deprecate unused assets](https://atlan.com/mcp-cookbook/safely-deprecate-unused-assets/): Verify no active consumers exist, notify owners, then mark assets as deprecated.
- [Sync metadata across environments](https://atlan.com/mcp-cookbook/sync-metadata-across-environments/): Keep descriptions, tags, and custom metadata aligned across dev, staging, and prod.
- [Score assets for AI readiness](https://atlan.com/mcp-cookbook/score-assets-for-ai-readiness/): Rate assets on documentation, ownership, and quality before they enter AI pipelines.

[Browse all recipes](https://atlan.com/mcp-cookbook/) / [Set up Atlan MCP](https://docs.atlan.com/product/capabilities/atlan-ai/how-tos/remote-mcp-overview)