Stefan-Koch
Databricks Partner

yes, you could use SQL to read the data from the volume:

%sql
SELECT * FROM json.`/Volumes/demo/raw/files/ergast/my_results.json`

StefanKoch_0-1740549044779.png

You still have to flatten the result.

The thing with the shell was just an example. Wouldn't recommend that, just use python