{"columns":[{"name":"system_id","type":"int32"},{"name":"metric_id","type":"int32"},{"name":"sensor_name","type":"string"},{"name":"common_name","type":"string"},{"name":"raw_units","type":"string"},{"name":"units","type":"string"},{"name":"calc_scale","type":"double"},{"name":"calc_offset","type":"double"},{"name":"calc_details","type":"string"},{"name":"aggregation_type","type":"string"},{"name":"source_type","type":"string"},{"name":"source_id","type":"int32"},{"name":"comments","type":"string"},{"name":"standard_name","type":"string"}],"n_rows":23,"rows_kept":23,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"Amazon Redshift","schema":{"fields":[{"name":"system_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"metric_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"sensor_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"common_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"raw_units","type":"string","nullable":true,"metadata":null,"children":null},{"name":"units","type":"string","nullable":true,"metadata":null,"children":null},{"name":"calc_scale","type":"double","nullable":true,"metadata":null,"children":null},{"name":"calc_offset","type":"double","nullable":true,"metadata":null,"children":null},{"name":"calc_details","type":"string","nullable":true,"metadata":null,"children":null},{"name":"aggregation_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"source_id","type":"int32","nullable":true,"metadata":null,"children":null},{"name":"comments","type":"string","nullable":true,"metadata":null,"children":null},{"name":"standard_name","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional int32 field_id=-1 system_id (Int(bitWidth=32, isSigned=true));\n  optional int32 field_id=-1 metric_id (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 sensor_name (String);\n  optional binary field_id=-1 common_name (String);\n  optional binary field_id=-1 raw_units (String);\n  optional binary field_id=-1 units (String);\n  optional double field_id=-1 calc_scale;\n  optional double field_id=-1 calc_offset;\n  optional binary field_id=-1 calc_details (String);\n  optional binary field_id=-1 aggregation_type (String);\n  optional binary field_id=-1 source_type (String);\n  optional int32 field_id=-1 source_id (Int(bitWidth=32, isSigned=true));\n  optional binary field_id=-1 comments (String);\n  optional binary field_id=-1 standard_name (String);\n}\n"},"kv_metadata":[]}
[1203,2889,"ac_power","AC power","W","W",1.0,0.0,"ac_meter_1_power_kW+ac_meter_2_power_kW","avg",null,null,"","ac_power__2889"]
[1203,2890,"dc_power","DC power","W","W",1.0,0.0,"inv1_dc_power_hW+inv2_dc_power_hW","avg",null,null,"","dc_power__2890"]
[1203,2895,"inv1_ac_power_hW","AC power","W","W",100.0,0.0,"","avg",null,null,"","inv1_ac_power_hw__2895"]
[1203,2896,"inv1_dc_power_hW","DC power","W","W",100.0,0.0,"","avg",null,null,"","inv1_dc_power_hw__2896"]
[1203,2902,"inv2_ac_power_hW","AC power","W","W",100.0,0.0,"","avg",null,null,"","inv2_ac_power_hw__2902"]
[1203,2903,"inv2_dc_power_hW","DC power","W","W",100.0,0.0,"","avg",null,null,"","inv2_dc_power_hw__2903"]
[1203,2911,"ac_inverter_power","AC power","W","W",1.0,0.0,"inv1_ac_power_hW+inv2_ac_power_hW","avg",null,null,"","ac_inverter_power__2911"]
[1203,2898,"inv1_ac_current","AC current","A","A",1.0,0.0,"","avg",null,null,"","inv1_ac_current__2898"]
[1203,2905,"inv2_ac_current","AC current","A","A",1.0,0.0,"","avg",null,null,"","inv2_ac_current__2905"]
[1203,2909,"ac_meter_1_power_kW","AC power","kW","W",1000.0,0.0,"","avg",null,null,"","ac_meter_1_power_kw__2909"]
[1203,2910,"ac_meter_2_power_kW","AC power","kW","W",1000.0,0.0,"","avg",null,null,"","ac_meter_2_power_kw__2910"]
[1203,2901,"inv1_power_factor","AC other","-","-",1.0,0.0,"","avg",null,null,"","inv1_power_factor__2901"]
[1203,2908,"inv2_power_factor","AC other","-","-",1.0,0.0,"","avg",null,null,"","inv2_power_factor__2908"]
[1203,2897,"inv1_ac_voltage","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv1_ac_voltage__2897"]
[1203,2904,"inv2_ac_voltage","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv2_ac_voltage__2904"]
[1203,2893,"gh_irradiance","Irradiance GHI","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","gh_irradiance__2893"]
[1203,2894,"module_temp_F","Temperature module","C","C",0.5555556,-17.7777778,"","avg",null,null,"","module_temp_f__2894"]
[1203,2891,"ambient_temp_F","Temperature ambient","C","C",0.5555556,-17.7777778,"","avg",null,null,"","ambient_temp_f__2891"]
[1203,2899,"inv1_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv1_temp__2899"]
[1203,2906,"inv2_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv2_temp__2906"]
[1203,2892,"relative_humidity","Humidity","%","%",1.0,0.0,"","avg",null,null,"","relative_humidity__2892"]
[1203,2900,"inv1_error_code","System status","-","-",1.0,0.0,"","union",null,null,"","inv1_error_code__2900"]
[1203,2907,"inv2_error_code","System status","-","-",1.0,0.0,"","union",null,null,"","inv2_error_code__2907"]