hello. Is it possible to manage (or edit) the tabl...
# getting-started
r
hello. Is it possible to manage (or edit) the tables displayed in DataHub by Excel or other tools? For example, Firstly download from datahub to Excel about the data table and related information managed by the datahub, and then in Excel I can modify the data table information value (description, owner, etc.). Then, is it possible to register the modified Excel data to the datahub and reflect it to datahub?
b
r
Thank you for your help. I am user of datahub, not a developer. Is this default feature? In this case, Should I ask adding csv module to developer?
b
this is default feature.
m
Download from datahub to Excel is supported using the "CSV download" feature that is found under the
...
next to a search result page.
r
Thank you!! I can do download. Then I edit contents of file. and.. finally, How do I upload an Excel file whose contents to be reflected in DATAHUB?
b
Downloading the csv just gives you the list of urn. However, to update data you need to create the csv in the format that I gave. Then use a recipe to upload the csv.
r
Thank you for your help.. Is the recipe a yaml document?
I'm trying to reference two files in git. First csv file (Link: https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/examples/demo_data/csv_enricher_demo_data.csv) Second recipe yml file (Link: https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/examples/recipes/csv_enricher_to_datahub_rest.dhub.yml) If I predict the steps, first I organize the metadata in a csv file. And can I run the yml file? I have no experience with yml files. 😢
b
have you done any form of CLI ingestion to datahub? the step for ingesting the csv file is similar, run
datahub ingest -c <recipe.yml>
where the recipe.yml contains the path to the csv and how to connect to datahub
r
i will try !!!
b
@mammoth-bear-12532
Download from datahub to Excel is supported using the "CSV download" feature that is found under the
...
next to a search result page.
It would be nice to be able to download dataset schemas as well. We had those questions in our company
m
Which format do you suggest schemas should be downloadable in? Csv might be limiting as you can have nested schemas in Datahub.
b
Was thinking about CSVs...Nested fields could be flattened, right? Our requiremnt was for a Salesforce source
Do you see flattening as not a good option?
p
@mammoth-bear-12532 Hey Shirshanka, Why do I export to csv with only the title and no content?