I am trying to read in a JSON file with this in SQL Editor & it fails with None.get
CREATE TEMPORARY VIEW multilineJson
USING json
OPTIONS (path="/Volumes/my_catalog/my_schema/jsondir/test.json", multiline=true);
None.get is all the error it has.The permissions are fine, I have granted all privileges to all users & I am able to: LIST '/Volumes/my_catalog/my_schema/jsondir/test.json' without errors. The Diagnose error co-pilot wants me to use s3 path...
- What does the error None.get probably mean ? [I looked in Query History & it has the same error]
- Are Volumes not supported in path ? I tried with path="dbfs:/Volumes/my_catalog/my_schema/jsondir/test.json" also, but with no success.
- I also tried with
CREATE TEMPORARY VIEW multilineJson(author STRING, efficacy DOUBLE, rating INTEGER, custom_labels VARIANT) .. and same error.
Sample JSON used -
[
{
"author": "user1",
"efficacy": 0.0,
"rating": 5,
"custom_labels": [ "label1", "label2" ]
},
{
"author": "user2",
"efficacy": 0.9,
"rating": 4,
"custom_labels": [ "label3", "label4" ]
}
]
Thanks !