{"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":[]}
[1305,58,"ac_current_1","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_1__58"]
[1305,59,"dc_current_1","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_1__59"]
[1305,60,"ac_power_1","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_1__60"]
[1305,63,"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__63"]
[1305,64,"ac_current_2","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_2__64"]
[1305,65,"dc_current_2","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_2__65"]
[1305,66,"ac_power_2","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_2__66"]
[1305,69,"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__69"]
[1305,70,"ac_current_3","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_3__70"]
[1305,71,"dc_current_3","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_3__71"]
[1305,72,"ac_power_3","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_3__72"]
[1305,75,"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__75"]
[1305,76,"ac_power","AC power","W","W",1.0,0.0,"ac_power_1+ac_power_2+ac_power_3","avg",null,null,"","ac_power__76"]
[1305,77,"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__77"]
[1305,57,"ac_frequency","AC other","Hz","Hz",1.0,0.0,"","avg",null,null,"","ac_frequency__57"]
[1305,61,"ac_voltage_1","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_1__61"]
[1305,67,"ac_voltage_2","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_2__67"]
[1305,73,"ac_voltage_3","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_3__73"]
[1305,55,"module_temp_F","Temperature module","C","C",0.5555556,-17.7777778,"","avg",null,null,"","module_temp_f__55"]
[1305,54,"ambient_temp_F","Temperature ambient","C","C",0.5555556,-17.7777778,"","avg",null,null,"","ambient_temp_f__54"]
[1305,62,"dc_voltage_1","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_1__62"]
[1305,68,"dc_voltage_2","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_2__68"]
[1305,74,"dc_voltage_3","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_3__74"]
[1305,53,"IntSolIrrad","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","intsolirrad__53"]
[1305,78,"error","System status","-","-",1.0,0.0,"","union",null,null,"","error__78"]
[1305,56,"wind_speed_mph","Wind speed","m/s","m/s",0.44704,0.0,"","median",null,null,"","wind_speed_mph__56"]