CREATE view USING json and *include* _metadata, _rescued_data

ChristianRRL
Honored Contributor

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:

ChristianRRL_0-1731949214474.png

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

ChristianRRL_1-1731949348303.png