Lakshay
Databricks Employee
Databricks Employee

You should be able to read the json file with below code.

val df = spark.read.format("json").load("file.json")

After this you will need to use the explode function to add columns to the dataframe using the nested values.