Attempting to load a JSON file fails due to schema issue (Free Edition)

chris84
Databricks Partner

Hello,

I created a Volume named 'test_volume' under catalog:workspace and schema:default.

Then I uploaded a file named user_0.json into test_volume (fake data, of course):

chris84_1-1767792178558.png

Now I want to load that file into a data frame.

With Python in a notebook:

chris84_0-1767792125532.png

With SQL:

chris84_2-1767792435608.png

Apparently there is a problem with the schema. But how is that possible given how primitive the JSON object is?

What am I doing wrong here?

Thanks