CREATE view USING json and *include* _metadata, _rescued_data

[ChristianRRL]

Title may be self-explanatory. Basically, I'm curious to ask if it's possible (and if so how) to add `_metadata` and `_rescued_data` fields to a view "using json".

e.g.

%sql

CREATE OR REPLACE VIEW entity_view
USING json
OPTIONS (path="/.../.*json",multiline=true)

Below I show it's possible to do this with `read_files` in Spark SQL:

Below I show an error trying to query these fields.. not sure if I'm doing something wrong:

[ChristianRRL]

Forgot to add this as reference:

• JSON Files - Spark 3.5.3 Documentation

The JSON Files documentation doesn't seem to show any OPTIONS that may enable the functionality that I'm looking for.. But please feel free to correct me if there's a way to achieve what I'm looking for that I may be overlooking!