{"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":[]}
[1307,84,"ac_current_1","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_1__84"]
[1307,85,"dc_current_1","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_1__85"]
[1307,86,"ac_power_1","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_1__86"]
[1307,89,"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__89"]
[1307,90,"ac_current_2","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_2__90"]
[1307,91,"dc_current_2","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_2__91"]
[1307,92,"ac_power_2","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_2__92"]
[1307,95,"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__95"]
[1307,96,"ac_current_3","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current_3__96"]
[1307,97,"dc_current_3","DC current","A","A",1.0,0.0,"","avg",null,null,"","dc_current_3__97"]
[1307,98,"ac_power_3","AC power","W","W",1.0,0.0,"","avg",null,null,"","ac_power_3__98"]
[1307,101,"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__101"]
[1307,102,"ac_power","AC power","W","W",1.0,0.0,"ac_power_1+ac_power_2+ac_power_3","avg",null,null,"","ac_power__102"]
[1307,103,"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__103"]
[1307,83,"ac_frequency","AC other","Hz","Hz",1.0,0.0,"","avg",null,null,"","ac_frequency__83"]
[1307,87,"ac_voltage_1","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_1__87"]
[1307,93,"ac_voltage_2","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_2__93"]
[1307,99,"ac_voltage_3","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage_3__99"]
[1307,81,"module_temp_F","Temperature module","C","C",0.5555556,-17.7777778,"","avg",null,null,"","module_temp_f__81"]
[1307,80,"ambient_temp_F","Temperature ambient","C","C",0.5555556,-17.7777778,"","avg",null,null,"","ambient_temp_f__80"]
[1307,88,"dc_voltage_1","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_1__88"]
[1307,94,"dc_voltage_2","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_2__94"]
[1307,100,"dc_voltage_3","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","dc_voltage_3__100"]
[1307,79,"IntSolIrrad","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","intsolirrad__79"]
[1307,104,"error","System status","-","-",1.0,0.0,"","union",null,null,"","error__104"]
[1307,82,"wind_speed_mph","Wind speed","m/s","m/s",0.44704,0.0,"","median",null,null,"","wind_speed_mph__82"]