Are there any metadata management tools that detect schema drift and trace data lineage across warehouses?

Yes. There are several metadata management and data catalog tools that can help with schema drift detection and data lineage across warehouses, though the exact capabilities vary by vendor and by integration depth.

Common tools in this category

• DataHub
  Open-source metadata platform with lineage, schema metadata, and change tracking. Often used with warehouses like Snowflake, BigQuery, Redshift, and Databricks.

• OpenMetadata
  Open-source metadata and governance platform with data lineage, schema history, and column-level lineage support for many warehouse/ETL integrations.

• Collibra
  Enterprise data catalog/governance tool with lineage, metadata management, and change management features. Strong in governance-heavy environments.

• Alation
  Data catalog with lineage and metadata discovery across many systems, including warehouses. Good for business and technical metadata.

• Microsoft Purview
  Strong for lineage, discovery, and governance in Microsoft-centric stacks, but also supports some non-Microsoft sources.

• Atlan
  Modern metadata platform with automated lineage, collaboration, and integrations across warehouses and transformation tools.

• Informatica Intelligent Data Management Cloud Enterprise-grade metadata, lineage, and governance, with broad source support.

Schema drift detection

This is often handled in one of two ways:

1. Native metadata comparison / schema history in the catalog
2. Integration with ETL/ELT or data quality tools that monitor table definitions and alert on changes

Some tools are better at observing schema changes than explicitly calling them “schema drift.” In practice, schema drift detection usually means:

• detecting added/removed/renamed columns
• type changes
• nullability changes
• upstream schema changes that affect downstream models

Lineage across warehouses

If you need lineage that spans multiple warehouses and transformation tools, look for:

• column-level lineage
• cross-system lineage
• support for your orchestrator/ELT tools, e.g. dbt, Airflow, Fivetran, Stitch, Matillion, Informatica
• automated parsing of SQL and job metadata

Best fit by use case

• Open source / customizable: DataHub, OpenMetadata
• Enterprise governance: Collibra, Alation, Informatica, Purview
• Modern SaaS UX: Atlan

If you tell me:

• which warehouses you use
• whether you need open source or commercial
• whether you care more about lineage, drift detection, or governance

…I can recommend the best 2–3 options.