UserWarning: Using `classifications` as a field header is deprecated and will be unsupported in the future. Please use `[root] classifications` instead. warn("Using `classifications` as a field header is deprecated and will be unsupported in the future.

Question

I am trying to upload classification for columns in purview using pyapacheatlas upload_entities() function. However, I am keep getting this error message

UserWarning: Using classifications as a field header is deprecated and will be unsupported in the future. Please use [root] classifications instead.

warn("Using classifications as a field header is deprecated and will be unsupported in the future."

I did try changing column header to [root] classifications in excel BulkEntities worksheet. I am still getting same error. I am referring to this document: https://wjohnson.github.io/pyapacheatlas-docs/latest/readers/excel-config.html

[root]`` ``classifications assigns classifications to the uploaded entity. The value in the spreadsheet must match the classification’s formal name and not the friendly name. You can provide multiple classifications by delimiting with a semi-colon (;) by default. This is configurable in the ExcelConfiguration.

Note: You can only apply classifications to NEW entities by the design of the /entity/bulk endpoint. To update an existing entity’s classifications, you must do so programmatically with the classify_bulk_entities or classify_entity method.

Answer 1

Hi @Janvi

Greetings & Welcome to the Microsoft Q&A forum! Thank you for sharing your query.

It looks like you're getting a warning because the field header for classifications is being deprecated. The system now wants you to use [root] classifications instead of just classifications.

You mentioned that you've already updated the column header in your Excel sheet to [root] classifications, but you're still getting the same warning. Here's a quick checklist to make sure everything is in place:

Ensure that the column is exactly [root] classifications, no extra spaces or special characters.

Make sure that in the column, you're using the official classification names (the "formal" ones) and not the friendly names.

Keep in mind that the /entity/bulk method can only apply classifications to new entities. If you need to update existing entities, you should use classify_bulk_entities or classify_entity for that.

Also, make sure your Excel config is set up correctly, with the delimiter and other settings that match your setup.

If you're still seeing the warning after checking all that, it could be worth updating your pyapacheatlas package just in case there’s a fix or a change in the latest version.

For more details refer to this: SQL Data Discovery and Classification

I hope this information helps.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.