Data Catalog and Discovery
A data catalog is an organized inventory of data assets (tables, files, streams, dashboards, and services) described with metadata so people and systems can find, understand, and decide whether to use them.
itData engineering and analytics | OpenSkills.info
Course pathWalk it in order
Look it upDip in anytime
Go furtherLeaves this page
Don't Panic
Don't Panic — Data Catalog and Discovery
A data catalog is an organized inventory of data assets (tables, files, streams, dashboards, services) described with metadata. It does not store your rows. It stores enough context that a stranger on a Tuesday can find the right asset and decide whether to trust it.
Before catalogs, people asked around. That works until the company has more tables than hallway conversations.
Three ideas carry almost everything else.
First, separate the dataset (the logical collection) from a distribution (a concrete way to get it) and from a catalog record (the registration of that description). Tools rename these; the jobs stay put.
Second, discovery needs four metadata layers: technical, business, operational, and relationship. Crawlers are good at the first. Owners, glossary terms, freshness, and lineage do the rest. Search that only knows column types returns structurally plausible assets nobody should ship a board metric from.
Third, metadata arrives by pull, push, and curation. Nightly crawls create coverage and staleness. Push events create fresher contracts when producers cooperate. Humans still have to write the sentence that says what the table is for.
The surprise: installing connectors is not the hard part. Empty descriptions, missing owners, and ghost entries for deleted tables are. Architecture essays about crawl-only portals versus event-sourced metadata platforms exist because trust dies when the inventory looks complete and feels wrong.
A catalog is also not your engine metastore, even when one cloud product plays both roles. The metastore helps compute read data. The catalog helps people discover assets across systems and attach ownership and policy context. Governance sets rules; lineage answers path questions; the catalog is where those meet the inventory.
Catalogs pay off when many teams produce and consume data across platforms and reuse matters. They are weak when a handful of well-known datasets already have clear owners, or when nobody will curate business metadata. In those cases the portal becomes a polite index of abandoned schemas.
If you read one more tab, use the intro for the full map, the cheatsheet for the layer and failure tables, Field Notes for the adoption traps, and Landscape when you need to compare products in this course's vocabulary.
Where this skill leads
Relevant careers
See how this topic contributes to broader role-level skill maps.
Sources
- https://www.w3.org/TR/vocab-dcat-3/
Supports
- A data catalog is a curated collection of metadata about resources
- DCAT defines Catalog, Dataset, Distribution, DataService, DatasetSeries, and CatalogRecord
- Standard catalog metadata supports discovery, aggregation, and interoperability across catalogs
- A Distribution is an accessible form of a dataset such as a downloadable file
- A CatalogRecord captures registration metadata about a catalog entry
- DCAT 3 adds versioning and dataset series while remaining compatible with DCAT 2
- https://www.w3.org/TR/2014/REC-vocab-dcat-20140116/
Supports
- DCAT became a W3C Recommendation in January 2014
- https://www.w3.org/TR/2020/REC-vocab-dcat-2-20200204/
Supports
- DCAT 2 became a W3C Recommendation in February 2020
- DCAT 2 expanded support for data services and broader catalog resources
- https://strategy.data.gov/practices/
Supports
- Organizations should inventory data assets with sufficient metadata for discovery and collaboration
- Documentation should cover quality, utility, and provenance and remain current
- https://docs.datahub.com/docs/introduction
Supports
- DataHub is an open-source metadata platform for discovery, governance, and observability
- DataHub originated at LinkedIn and catalogs many asset types across a data ecosystem
- https://docs.open-metadata.org/latest/how-to-guides/data-discovery
Supports
- OpenMetadata aggregates metadata so users can discover assets with search, associations, and queries
- Discovery UIs surface asset detail, lineage context, and rich metadata for many asset types
- https://atlas.apache.org/
Supports
- Apache Atlas provides open metadata management and governance capabilities for building a catalog of data assets
- https://docs.aws.amazon.com/glue/latest/dg/catalog-and-crawler.html
Supports
- The AWS Glue Data Catalog stores metadata about datasets as an index of location, schema, and related properties
- Crawlers can automatically discover and catalog data sources
- The Glue Data Catalog integrates with AWS analytics services as a shared metadata layer
- https://aws.amazon.com/about-aws/whats-new/2017/08/introducing-aws-glue-a-simple-flexible-and-cost-effective-extract-transfer-and-load-etl-service/
Supports
- AWS Glue became generally available in August 2017 with a Data Catalog populated by discovery of data sources
- https://learn.microsoft.com/en-us/purview/unified-catalog
Supports
- Federated governance combines centralized standards with distributed ownership across business domains
- https://www.linkedin.com/blog/engineering/data-management/datahub-popular-metadata-architectures-explained
Supports
- First-generation catalogs often use pull-based crawling into a monolith with search and optional graph indexes
- Crawl-only freshness suffers when crawlers pause or run infrequently
- Second-generation designs add push APIs for programmatic metadata use
- Third-generation designs center an event-sourced metadata log that can rebuild indexes and support subscribers
- Split catalogs for discovery and governance create sync and drift problems
- WhereHows was open sourced in 2016 and DataHub was re-shared in 2019
- https://eng.lyft.com/open-sourcing-amundsen-a-data-discovery-and-metadata-platform-2282bb436234
Supports
- Amundsen is a search-first data discovery and metadata platform open-sourced by Lyft
- Usage signals from query logs can improve search ranking
- Ownership and people-to-table relationships are part of scalable discovery
- Stale metadata remains after source deletes unless cleanup jobs remove it
- Amundsen was formally announced as open source in October 2019 after an earlier soft launch
- https://www.linkedin.com/blog/engineering/open-source/open-sourcing-datahub-linkedins-metadata-search-and-discovery-p
Supports
- LinkedIn open-sourced DataHub as the successor to WhereHows for metadata search and discovery
- https://techcrunch.com/2016/03/03/linkedin-open-sources-its-wherehows-data-discovery-and-lineage-portal/
Supports
- LinkedIn open-sourced WhereHows in March 2016 as a metadata portal for discovery and lineage
- https://incubator.apache.org/projects/atlas.html
Supports
- Apache Atlas entered incubation on 2015-05-06
- Apache Atlas graduated on 2017-06-21
- https://blog.open-metadata.org/announcing-openmetadata-20399b816e60
Supports
- OpenMetadata was announced in August 2021 as an open-source centralized metadata store and discovery UI
- Duplicated metadata across tools becomes inconsistent and forces users to context-switch
- https://www.w3.org/TR/prov-o/
Supports
- PROV-O provides a provenance ontology used when catalog discovery connects to lineage interchange
- https://www.w3.org/TR/2024/REC-vocab-dcat-3-20240822/
Supports
- DCAT 3 was published as a W3C Recommendation on 22 August 2024
- https://github.com/opendatadiscovery/awesome-data-catalogs
Supports
- Community-curated inventory of open-source and commercial data catalog and related governance tools
