{"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":98,"rows_kept":98,"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":[]}
[4902,82596,"AmbTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2205,"","temperature_ambient_o_2205"]
[4902,82673,"Battery_A_Avg","DC current battery","A","A",1.0,0.0,"","avg","",null,"","battery_a_avg__82673"]
[4902,82672,"Battery_V_Min","DC voltage battery","V","V",1.0,0.0,"","min","",null,"","battery_v_min__82672"]
[4902,82591,"CR1000Temp_C_Avg","Temperature enclosure","C","C",1.0,0.0,"","avg","OTHER",null,"","cr1000temp_c_avg__82591"]
[4902,82676,"ChgSource_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgsource_min__82676"]
[4902,82675,"ChgState_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgstate_min__82675"]
[4902,82677,"CkBatt_Max","Battery other","-","-",1.0,0.0,"","max","",null,"","ckbatt_max__82677"]
[4902,82608,"InvEtot_kWh_Max","AC energy","kWh","kWh",1.0,0.0,"","max","INVERTER",14538,"","ac_energy_inv_14538"]
[4902,82601,"InvIa_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14538,"","ac_current_other_inv_14538"]
[4902,82602,"InvIb_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14538,"","ac_current_other_inv_14538_2"]
[4902,82603,"InvIc_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14538,"","ac_current_other_inv_14538_3"]
[4902,82607,"InvPAC_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","INVERTER",14538,"","ac_power_inv_14538"]
[4902,82610,"InvPDC_kW_Avg","DC power","kW","kW",1.0,0.0,"","avg","INVERTER",14538,"","dc_power_inv_14538"]
[4902,82616,"InvTempFault_Max","Temperature inverter","-","-",1.0,0.0,"","max","INVERTER",14538,"","temperature_inverter_inv_14538"]
[4902,82604,"InvVDCin_Avg","DC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","dc_voltage_other_inv_14538"]
[4902,82609,"InvVPVin_Avg","DC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","dc_voltage_other_inv_14538_2"]
[4902,82598,"InvVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","ac_voltage_other_inv_14538"]
[4902,82599,"InvVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","ac_voltage_other_inv_14538_2"]
[4902,82600,"InvVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","ac_voltage_other_inv_14538_3"]
[4902,82638,"PwrMtrEdel_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1864,"","ac_power_meter_1864"]
[4902,82636,"PwrMtrEdel_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1864,"","ac_power_meter_1864_2"]
[4902,82639,"PwrMtrErec_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1864,"","ac_power_meter_1864_3"]
[4902,82637,"PwrMtrErec_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1864,"","ac_power_meter_1864_4"]
[4902,82628,"PwrMtrFreqMax_Max","AC other","Hz","Hz",1.0,0.0,"","max","METER",1864,"","ac_other_meter_1864"]
[4902,82627,"PwrMtrFreqMin_Min","AC other","Hz","Hz",1.0,0.0,"","min","METER",1864,"","ac_other_meter_1864_2"]
[4902,82626,"PwrMtrFreq_Avg","AC other","Hz","Hz",1.0,0.0,"","avg","METER",1864,"","ac_other_meter_1864_3"]
[4902,82640,"PwrMtrPF_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1864,"","ac_power_other_meter_1864"]
[4902,82634,"PwrMtrP_kVAR_Avg","AC power other","kVAR","kVAR",1.0,0.0,"","avg","METER",1864,"","ac_power_other_meter_1864_2"]
[4902,82635,"PwrMtrP_kVA_Avg","AC power other","kVA","kVA",1.0,0.0,"","avg","METER",1864,"","ac_power_other_meter_1864_3"]
[4902,82633,"PwrMtrP_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","METER",1864,"","ac_power_meter_1864_5"]
[4902,82629,"PwrMtrPhaseRev_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1864,"","ac_power_other_meter_1864_4"]
[4902,82641,"PwrMtrVaTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1864,"","ac_voltage_other_meter_1864"]
[4902,82630,"PwrMtrVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1864,"","ac_voltage_other_meter_1864_2"]
[4902,82642,"PwrMtrVbTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1864,"","ac_voltage_other_meter_1864_3"]
[4902,82631,"PwrMtrVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1864,"","ac_voltage_other_meter_1864_4"]
[4902,82643,"PwrMtrVcTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1864,"","ac_voltage_other_meter_1864_5"]
[4902,82632,"PwrMtrVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1864,"","ac_voltage_other_meter_1864_6"]
[4902,82593,"Pyra1_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2202,"","irradiance_ghi_o_2202"]
[4902,82594,"Pyra2_mV_Avg","Irradiance POA","mV","mV",1.0,0.0,"","avg","OTHER",2203,"","irradiance_poa_o_2203"]
[4902,82679,"RTD_C_Avg_1","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_1__82679"]
[4902,82688,"RTD_C_Avg_10","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_10__82688"]
[4902,82680,"RTD_C_Avg_2","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_2__82680"]
[4902,82681,"RTD_C_Avg_3","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_3__82681"]
[4902,82682,"RTD_C_Avg_4","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_4__82682"]
[4902,82683,"RTD_C_Avg_5","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_5__82683"]
[4902,82684,"RTD_C_Avg_6","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_6__82684"]
[4902,82685,"RTD_C_Avg_7","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_7__82685"]
[4902,82686,"RTD_C_Avg_8","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_8__82686"]
[4902,82687,"RTD_C_Avg_9","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_9__82687"]
[4902,82595,"RefCell1_Wm2_Avg","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2204,"","irradiance_poa_o_2204"]
[4902,82620,"SEWSAmbientTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2206,"","temperature_ambient_o_2206"]
[4902,82621,"SEWSModuleTemp_C_Avg","Temperature module","C","C",1.0,0.0,"","avg","OTHER",2206,"","temperature_module_o_2206"]
[4902,82644,"ShuntCurrent_A_Avg_1","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_1__82644"]
[4902,82645,"ShuntCurrent_A_Avg_2","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_2__82645"]
[4902,82646,"ShuntCurrent_A_Avg_3","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_3__82646"]
[4902,82647,"ShuntCurrent_A_Avg_4","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_4__82647"]
[4902,82648,"ShuntCurrent_A_Avg_5","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_5__82648"]
[4902,82649,"ShuntCurrent_A_Avg_6","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_6__82649"]
[4902,82650,"ShuntCurrent_A_Avg_7","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_7__82650"]
[4902,82658,"ShuntEtot_kWh_Max_1","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_1__82658"]
[4902,82659,"ShuntEtot_kWh_Max_2","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_2__82659"]
[4902,82660,"ShuntEtot_kWh_Max_3","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_3__82660"]
[4902,82661,"ShuntEtot_kWh_Max_4","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_4__82661"]
[4902,82662,"ShuntEtot_kWh_Max_5","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_5__82662"]
[4902,82663,"ShuntEtot_kWh_Max_6","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_6__82663"]
[4902,82664,"ShuntEtot_kWh_Max_7","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_7__82664"]
[4902,82651,"ShuntPDC_kW_Avg_1","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_1__82651"]
[4902,82652,"ShuntPDC_kW_Avg_2","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_2__82652"]
[4902,82653,"ShuntPDC_kW_Avg_3","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_3__82653"]
[4902,82654,"ShuntPDC_kW_Avg_4","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_4__82654"]
[4902,82655,"ShuntPDC_kW_Avg_5","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_5__82655"]
[4902,82656,"ShuntPDC_kW_Avg_6","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_6__82656"]
[4902,82657,"ShuntPDC_kW_Avg_7","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_7__82657"]
[4902,82622,"SEWSPOAIrrad_Wm2_Avg","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2206,"","irradiance_poa_o_2206"]
[4902,82670,"WindHeatStateID_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2206,"","wind_other_o_2206_2"]
[4902,82669,"WindRef_V_Min","AC other","V","V",1.0,0.0,"","min","OTHER",2206,"","wind_other_o_2206_3"]
[4902,82668,"WindSpeed_ms_Max","AC other","m/s","m/s",1.0,0.0,"","max","OTHER",2206,"","wind_speed_o_2206_2"]
[4902,82671,"WindValid_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2206,"","wind_other_o_2206_4"]
[4902,82592,"DoorOpen_Min","System other","-","-",1.0,0.0,"","min","",null,"","dooropen_min__82592"]
[4902,82613,"InvDriveFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538"]
[4902,82606,"InvFreq_Avg","System other","Hz","Hz",1.0,0.0,"","avg","INVERTER",14538,"","system_other_inv_14538_2"]
[4902,82615,"InvGridFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_3"]
[4902,82605,"InvIDCin_Avg","System other","A","A",1.0,0.0,"","avg","INVERTER",14538,"","system_other_inv_14538_4"]
[4902,82612,"InvMainFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_5"]
[4902,82611,"InvOpStatus_Avg","System other","-","-",1.0,0.0,"","avg","INVERTER",14538,"","system_other_inv_14538_6"]
[4902,82619,"InvPVMStatus_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_7"]
[4902,82617,"InvSystemFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_8"]
[4902,82618,"InvSystemWarn_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_9"]
[4902,82597,"InvVDVoltage_V_Avg","System other","V","V",1.0,0.0,"","avg","INVERTER",14538,"","system_other_inv_14538_10"]
[4902,82614,"InvVoltageFault_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14538,"","system_other_inv_14538_11"]
[4902,82674,"Load_A_Avg","System other","A","A",1.0,0.0,"","avg","",null,"","load_a_avg__82674"]
[4902,82623,"PwrMtrIa_Avg","System other","A","A",1.0,0.0,"","avg","METER",1864,"","system_other_meter_1864"]
[4902,82624,"PwrMtrIb_Avg","System other","A","A",1.0,0.0,"","avg","METER",1864,"","system_other_meter_1864_2"]
[4902,82625,"PwrMtrIc_Avg","System other","A","A",1.0,0.0,"","avg","METER",1864,"","system_other_meter_1864_3"]
[4902,82678,"Qloss_Ah_Max","System other","Ah","Ah",1.0,0.0,"","max","",null,"","qloss_ah_max__82678"]
[4902,82666,"WindDirAve_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2206,"","wind_direction_o_2206"]
[4902,82667,"WindDirStdDev_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2206,"","wind_other_o_2206"]
[4902,82665,"WindSpeedAve_ms","AC other","m/s","m/s",1.0,0.0,"","wvc","OTHER",2206,"","wind_speed_o_2206"]