展开json

WITH raw_props AS (
SELECT event AS event_name, properties AS props
FROM di_edw.dwd_iov_buried_fact_sensors_data_di
WHERE dt = '${yesterday}'
AND data_source = 'ai_center'
AND track_id = '-1007780528'
)
select map_keys(from_json(props,'map<string,string>')) from raw_props;