-werners-
Esteemed Contributor III

Not a literal answer:

https://docs.databricks.com/spark/latest/dataframes-datasets/complex-nested-data.html

https://databricks.com/blog/2017/02/23/working-complex-data-formats-structured-streaming-apache-spar...

You can try to achieve this using a defined schema, and then read the table, or more advanced technique like regex etc.

There are quite some options when working with nested data as you will see.

You could even work with delta lake and check constraints.

(https://docs.microsoft.com/en-us/azure/databricks/delta/delta-constraints)