open-metadata / OpenMetadata

OpenMetadata is a unified metadata platform for data discovery, data observability, and data governance powered by a central metadata repository, in-depth column level lineage, and seamless team collaboration.
https://open-metadata.org
Apache License 2.0
5.59k stars 1.05k forks source link

Adjust Ingestion to be "Table Aware" #18691

Open eladrus opened 2 days ago

eladrus commented 2 days ago

As part of our efforts for building a real time table ingestion service to OMD we're using the Ingestion Framework External Deployment with Trino Metadata Ingestion. We see that some tables are taking very long to be ingested, around 5-10 minutes although their schema is very thin. It seems that there is a preprocessor phase that retrieves table comments and uses a filter on schema level: https://github.com/open-metadata/OpenMetadata/blob/main/ingestion/src/metadata/ingestion/source/database/trino/queries.py#L34 when ingesting only 1 table in an event driven architecture is seems like an overkill. Table comments retrieval should be aware of any tables filtered in tableFilterPattern key of the YAML configuration. Relevant Slack thread: https://openmetadata.slack.com/archives/C02B6955S4S/p1724075683883439

TeddyCr commented 13 hours ago

cc @ulixius9