VIEW JSON result value in view which based on volume
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-09-2024 08:06 AM
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?