A hierarchically organized field for denormalized values

[ap-jan1]

Hello community!

I have MS SQL Server as a data source. It has a table in which column X contains denormalized values in the form of JSON (for example, { "data": { "innerdata": 123 } } ).
I know there are tags and custom properties, but that's not what I need. I want to see X not as an ordinary string field, but as hierarchically organized (possibly, nested tables).
What tools are available in OpenMetaData to show such columns with "complex" data types?

Thank you for your answers!

[jojo599k]

Hi ap-jan1,
i'm not sure if I understand your question correctly. Are you asking do display the content of rows in OpenMetadata? Do you mean that the column itself has a nested JSON "name/identifier" and you want structure the columns and tables in that way? Or do you mean you that you can map your schema in OpenMetadata?

For 1) Maybe the values you are trying to represent are not metadata but data and you could maybe consider using a data analysis tool and not a data discovery tool.
For 2) You probably want to write a custom ingestion script.
For 3) As per my understanding of the schema it should be possible to do so, but i'm not sure if the UI or API is limiting it.