Hello guys!
I have the following case:
It has been decided that the json file will be read from a following definition ( from volume) , which more or less looks like this:
CREATE OR REPLACE VIEW [catalog_name].[schema_name].v_[object_name]
AS
SELECT result, _metadata.file_path as etl_full_path, _metadata.file_modification_time as etl_inserted_at FROM json.`dbfs:/Volumes/[catalog_name]/[schema_name]/[volume_name]/object=[object_name]/`
I would like to read this view using SQL warehouse and I can not view result column value - there is a NULL value
despite the flag is turn on in view properties.
view.sqlConfig.spark.sql.legacy.json.allowEmptyString.enabled=true
Any tips?