question

MamunurRahmanDataGovernance-8816 avatar image
0 Votes"
MamunurRahmanDataGovernance-8816 asked KranthiPakala-MSFT commented

Purview - Attribute descriptions

Hi,

Is there a way in purview to automatically apply attribute descriptions that we have stored in a spreadsheet?

Thanks

azure-purview
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @mamunurrahmandatagovernance-8816,

Welcome to Microsoft Q&A forum and thanks for reaching out here.

Please refer to this article which describes step by step on how to create a business glossary term in Azure Purview data catalog, and import and export glossary terms using .csv files.

Hope this helps. Do let us know if you have further query.


  • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Apologies, i did not receive a notification to say you had replied back to me.

No this is not what i meant. At an attribute level we have descriptions for each attributes for all the different schemas we have.

This is not a glossary functionality that i am after, we have done this already.

I want to be able to populate descriptions to my schema attributes with the descriptions I have in a spreadsheet.

Is there a way to do this automatically rather than manually doing this one by one?

142869-image.png


1 Vote 1 ·
image.png (62.8 KiB)
KranthiPakala-MSFT avatar image KranthiPakala-MSFT MamunurRahmanDataGovernance-8816 ·

Hi @mamunurrahmandatagovernance-8816,

Thanks for getting back and clarifying on the requirement.
I am reaching out to product team to check if there is a way to achieve this in an automatic way rather than doing it manually. Will keep you posted as soon as I have an update from the team.

We appreciate your patience.

Thank you

0 Votes 0 ·

Hi @mamunurrahmandatagovernance-8816,

We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

Thank you.

0 Votes 0 ·
KranthiPakala-MSFT avatar image
1 Vote"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @mamunurrahmandatagovernance-8816,

As per conversation with internal team, you may try leveraging PyApacheAtlas : https://github.com/wjohnson/pyapacheatlas. PyApacheAtlas is a very convenient way of just getting massive amounts of data into Purview via an Excel interface and a little bit of Python!

Here is a video on how to do bulk uploads with an excel file: https://www.youtube.com/watch?v=27jRUydL6qE

You'll need the following:

  1. Install PyApacheAtlas and either get a service principal access to Purview or use the Azure CLI

  2. Generate the excel template using the python -m pyapacheatlas --make-template ./purview.xlsx command

  3. You will add the information to the BulkEntities tab.
    - Each row of the spreadsheet represents one column
    - Need the qualified name of the columns (e.g. mssql://server/db/schema/table#columnName)
    - Need the type name of the columns (e.g. azure_sql_column if it’s a column on an azure sql table)

  4. For the bulk entities spreadsheet, you’ll need to add a column called “description” and fill in the descriptions for the given column.

  5. you can then modify and run the sample script: https://github.com/wjohnson/pyapacheatlas/blob/master/samples/excel/excel_bulk_entities_upload.py
    - Please note that you should comment out lines 76 and 78 and update the file_path variable


Hope this helps. Do let us know how it goes.


  • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification

  • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @mamunurrahmandatagovernance-8816,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·

Hi @KranthiPakala-MSFT,

Not had a chance to try this yet will give it a go.

Thanks
Mamzy

0 Votes 0 ·
KranthiPakala-MSFT avatar image KranthiPakala-MSFT MamunurRahmanDataGovernance-8816 ·

Hi @mamunurrahmandatagovernance-8816,

Thanks for your response. Please keep us posted how it goes.

Thank you

0 Votes 0 ·