Hi team :smiling_face_with_tear: Is there a way to...
# ingestion
n
Hi team 🥲 Is there a way to sink data to file
from datahub
? I want to save it like a snapshot of current status of datahub, and i want it to be the same json format that is used for sink (or data source), so i can customize them and ingest it to datahub later. (Or is there any other way to solve this via mysql DB... etc?)
s
reading current state from datahub into file? You can go through the APIs and query the data. But it is not as simple currently as the metadata ingestion framework
what kind of customizations are you looking for?
maybe instead of the kafka or rest sink you can use file sink which will give what is ingested into a file
you can use that file as a base for your transformations
n
Hi @square-activity-64562 , thank you for the reply
You can go through the APIs and query the data.->
Can you elaborate them or is there a doc that i can refer to? What i want to do is, • I want to update metadata from a data source every day, • But I want to keep a separate json file, so i can specifically choose whether i will reflect the change to the datahub system (column-specific, etc.. ) • But during the same time, there will be other people editing things via Datahub UI • So i think i have to fetch current status from datahub to file first (to avoid conflict), then edit the json file, then ingest it to datahub
s
https://datahubproject.io/docs/api/graphql/overview/ @nice-planet-17111 I have not used it myself so far. But I think team said this is the primary API for querying data
n
Thank you for sharing, i will check it ! 🙂
m
Thanks @square-activity-64562. @nice-planet-17111, hopefully your questions are answered!
@nice-planet-17111, just FYI - metadata that is added via the UI (user editable info) does not get overridden across ingestion runs.
s
@miniature-tiger-96062 That is not true for all cases. Some things do get overwritten by metadata ingestion. You can talk with @mammoth-bear-12532 for details. He had mentioned that team is looking at cleaning this up over time