Reading JSON file to columns as relational ?

======================================

Thanks for reviewing my threads. I like to explore Reading JSON file to columns as relational  within Databricks.

I have input file at workspace path > path\receipt.json

I have schema at workspace path > path\receipt.schema.json

How can I read the input json file binding with schema and output the data in relational columns?

I like to have both option with SQL , pyspark.

What to do with errors while parsing ?

Are there any doc/whitepapers on this subject?

Thanks for your insights.