George Leonard
04/30/2025, 7:25 PMINSERT INTO hive_catalog.iot.factory_iot_north_unnested
SELECT
ts,
metadata.siteId AS siteId,
metadata.deviceId AS deviceId,
metadata.sensorId AS sensorId,
metadata.unit AS unit,
metadata.ts_human AS ts_human,
metadata.location.latitude AS latitude,
metadata.location.longitude AS longitude,
metadata.deviceType AS deviceType,
measurement
FROM hive_catalog.iot.factory_iot_north;