{"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":26,"rows_kept":26,"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":[]}
[1312,179,"ac_current_1","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_1__179"]
[1312,180,"dc_current_1","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_1__180"]
[1312,181,"ac_power_1","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_1__181"]
[1312,184,"dc_power_1_calc","DC power","W","W",1.0,0.0,"dc_current_1*dc_voltage_1","avg",null,null,"","dc_power_1_calc__184"]
[1312,185,"ac_current_2","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_2__185"]
[1312,186,"dc_current_2","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_2__186"]
[1312,187,"ac_power_2","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_2__187"]
[1312,190,"dc_power_2_calc","DC power","W","W",1.0,0.0,"dc_current_2*dc_voltage_2","avg",null,null,"","dc_power_2_calc__190"]
[1312,191,"ac_current_3","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_3__191"]
[1312,192,"dc_current_3","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_3__192"]
[1312,193,"ac_power_3","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_3__193"]
[1312,196,"dc_power_3_calc","DC power","W","W",1.0,0.0,"dc_current_3*dc_voltage_3","avg",null,null,"","dc_power_3_calc__196"]
[1312,197,"ac_power","AC power","W","W",1.0,0.0,"ac_power_1+ac_power_2+ac_power_3","avg",null,null,"","ac_power__197"]
[1312,198,"dc_power","DC power","W","W",1.0,0.0,"dc_power_1_calc+dc_power_2_calc+dc_power_3_calc","avg",null,null,"","dc_power__198"]
[1312,178,"ac_frequency","AC other","Hz","Hz",1.0,0.0,"","avg",null,null,"","ac_frequency__178"]
[1312,182,"ac_voltage_1","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_1__182"]
[1312,188,"ac_voltage_2","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_2__188"]
[1312,194,"ac_voltage_3","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_3__194"]
[1312,176,"module_temp_F","Temperature module","C","C",0.5555556,-17.7777778,"","avg",null,null,"","module_temp_f__176"]
[1312,175,"ambient_temp_F","Temperature ambient","C","C",0.5555556,-17.7777778,"","avg",null,null,"","ambient_temp_f__175"]
[1312,183,"dc_voltage_1","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_1__183"]
[1312,189,"dc_voltage_2","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_2__189"]
[1312,195,"dc_voltage_3","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_3__195"]
[1312,174,"IntSolIrrad","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","intsolirrad__174"]
[1312,199,"error","System status","-","-",1.0,0.0,"","union",null,null,"","error__199"]
[1312,177,"wind_speed_mph","Wind speed","m/s","m/s",0.44704,0.0,"","median",null,null,"","wind_speed_mph__177"]