{"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":121,"rows_kept":121,"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":[]}
[4903,82702,"AmbTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2217,"","temperature_ambient_o_2217"]
[4903,82785,"Battery_A_Avg","DC current battery","A","A",1.0,0.0,"","avg","",null,"","battery_a_avg__82785"]
[4903,82784,"Battery_V_Min","DC voltage battery","V","V",1.0,0.0,"","min","",null,"","battery_v_min__82784"]
[4903,82689,"CR1000Temp_C_Avg","Temperature enclosure","C","C",1.0,0.0,"","avg","OTHER",null,"","cr1000temp_c_avg__82689"]
[4903,82788,"ChgSource_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgsource_min__82788"]
[4903,82787,"ChgState_Min","Battery other","-","-",1.0,0.0,"","min","",null,"","chgstate_min__82787"]
[4903,82789,"CkBatt_Max","Battery other","-","-",1.0,0.0,"","max","",null,"","ckbatt_max__82789"]
[4903,82734,"InvEtoday_kWh_Max","AC energy","kWh","kWh",1.0,0.0,"","max","INVERTER",14539,"","ac_energy_inv_14539"]
[4903,82733,"InvEtot_kWh_Max","AC energy","kWh","kWh",1.0,0.0,"","max","INVERTER",14539,"","ac_energy_inv_14539_2"]
[4903,82735,"InvEyesterday_kWh_Max","AC energy","kWh","kWh",1.0,0.0,"","max","INVERTER",14539,"","ac_energy_inv_14539_3"]
[4903,82720,"InvINeutral_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539"]
[4903,82726,"InvIUnbal_Avg","AC current other","%","%",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539_2"]
[4903,82716,"InvIa_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539_3"]
[4903,82719,"InvIabcAvg_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539_4"]
[4903,82717,"InvIb_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539_5"]
[4903,82718,"InvIc_Avg","AC current other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","ac_current_other_inv_14539_6"]
[4903,82728,"InvPAC_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","INVERTER",14539,"","ac_power_inv_14539"]
[4903,82727,"InvPDC_kW_Avg","DC power","kW","kW",1.0,0.0,"","avg","INVERTER",14539,"","dc_power_inv_14539"]
[4903,82731,"InvPF_Avg","AC other","-","-",1.0,0.0,"","avg","INVERTER",14539,"","ac_other_inv_14539"]
[4903,82740,"InvTempHeatsink_C_Avg","Temperature inverter","C","C",1.0,0.0,"","avg","INVERTER",14539,"","temperature_inverter_inv_14539"]
[4903,82738,"InvTempInternalAir_C_Avg","Temperature inverter","C","C",1.0,0.0,"","avg","INVERTER",14539,"","temperature_inverter_inv_14539_2"]
[4903,82739,"InvTempInverterAir_C_Avg","Temperature inverter","C","C",1.0,0.0,"","avg","INVERTER",14539,"","temperature_inverter_inv_14539_3"]
[4903,82729,"InvVAR_kVAR_Avg","AC power other","kVAR","kVAR",1.0,0.0,"","avg","INVERTER",14539,"","ac_power_other_inv_14539"]
[4903,82730,"InvVA_kVA_Avg","AC power other","kVA","kVA",1.0,0.0,"","avg","INVERTER",14539,"","ac_power_other_inv_14539_2"]
[4903,82713,"InvVDCin_Avg","DC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","dc_voltage_other_inv_14539"]
[4903,82725,"InvVUnbal_Avg","AC voltage other","%","%",1.0,0.0,"","avg","INVERTER",14539,"","ac_voltage_other_inv_14539"]
[4903,82721,"InvVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","ac_voltage_other_inv_14539_2"]
[4903,82724,"InvVabcAvg_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","ac_voltage_other_inv_14539_3"]
[4903,82722,"InvVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","ac_voltage_other_inv_14539_4"]
[4903,82723,"InvVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","ac_voltage_other_inv_14539_5"]
[4903,82759,"PwrMtrEdel_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1865,"","ac_power_meter_1865"]
[4903,82757,"PwrMtrEdel_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1865,"","ac_power_meter_1865_2"]
[4903,82760,"PwrMtrErec_kVARh_Max","AC power","kVARh","kVARh",1.0,0.0,"","max","METER",1865,"","ac_power_meter_1865_3"]
[4903,82758,"PwrMtrErec_kWh_Max","AC power","kWh","kWh",1.0,0.0,"","max","METER",1865,"","ac_power_meter_1865_4"]
[4903,82749,"PwrMtrFreqMax_Max","AC other","Hz","Hz",1.0,0.0,"","max","METER",1865,"","ac_other_meter_1865"]
[4903,82748,"PwrMtrFreqMin_Min","AC other","Hz","Hz",1.0,0.0,"","min","METER",1865,"","ac_other_meter_1865_2"]
[4903,82747,"PwrMtrFreq_Avg","AC other","Hz","Hz",1.0,0.0,"","avg","METER",1865,"","ac_other_meter_1865_3"]
[4903,82761,"PwrMtrPF_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1865,"","ac_power_other_meter_1865"]
[4903,82755,"PwrMtrP_kVAR_Avg","AC power other","kVAR","kVAR",1.0,0.0,"","avg","METER",1865,"","ac_power_other_meter_1865_2"]
[4903,82756,"PwrMtrP_kVA_Avg","AC power other","kVA","kVA",1.0,0.0,"","avg","METER",1865,"","ac_power_other_meter_1865_3"]
[4903,82754,"PwrMtrP_kW_Avg","AC power","kW","kW",1.0,0.0,"","avg","METER",1865,"","ac_power_meter_1865_5"]
[4903,82750,"PwrMtrPhaseRev_Avg","AC power other","-","-",1.0,0.0,"","avg","METER",1865,"","ac_power_other_meter_1865_4"]
[4903,82762,"PwrMtrVaTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1865,"","ac_voltage_other_meter_1865"]
[4903,82751,"PwrMtrVa_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1865,"","ac_voltage_other_meter_1865_2"]
[4903,82763,"PwrMtrVbTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1865,"","ac_voltage_other_meter_1865_3"]
[4903,82752,"PwrMtrVb_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1865,"","ac_voltage_other_meter_1865_4"]
[4903,82764,"PwrMtrVcTHDMax_Max","AC voltage other","%","%",1.0,0.0,"","max","METER",1865,"","ac_voltage_other_meter_1865_5"]
[4903,82753,"PwrMtrVc_Avg","AC voltage other","V","V",1.0,0.0,"","avg","METER",1865,"","ac_voltage_other_meter_1865_6"]
[4903,82691,"Pyra1_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2206,"southwest","irradiance_ghi_o_2206"]
[4903,82692,"Pyra2_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2207,"southeast","irradiance_ghi_o_2207"]
[4903,82693,"Pyra3_mV_Avg","Irradiance POA","mV","mV",1.0,0.0,"","avg","OTHER",2208,"southeast","irradiance_poa_o_2208"]
[4903,82694,"Pyra4_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2209,"northwest","irradiance_ghi_o_2209"]
[4903,82695,"Pyra5_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2210,"northeast","irradiance_ghi_o_2210"]
[4903,82696,"Pyra6_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2211,"center","irradiance_ghi_o_2211"]
[4903,82697,"Pyra7_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2212,"","irradiance_ghi_o_2212"]
[4903,82698,"Pyra8_mV_Avg","Irradiance GHI","mV","mV",1.0,0.0,"","avg","OTHER",2213,"","irradiance_ghi_o_2213"]
[4903,82791,"RTD_C_Avg_1","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_1__82791"]
[4903,82792,"RTD_C_Avg_2","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_2__82792"]
[4903,82793,"RTD_C_Avg_3","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_3__82793"]
[4903,82794,"RTD_C_Avg_4","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_4__82794"]
[4903,82795,"RTD_C_Avg_5","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_5__82795"]
[4903,82796,"RTD_C_Avg_6","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_6__82796"]
[4903,82797,"RTD_C_Avg_7","Temperature backsheet","C","C",1.0,0.0,"","avg","OTHER",null,"module location varies by system","rtd_c_avg_7__82797"]
[4903,82699,"RefCell1_Wm2_Avg","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2214,"southwest","irradiance_poa_o_2214"]
[4903,82700,"RefCell2_Wm2_Avg","Irradiance GHI","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2215,"center","irradiance_ghi_o_2215"]
[4903,82701,"RefCell3_Wm2_Avg","Irradiance GHI","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2216,"center","irradiance_ghi_o_2216"]
[4903,82741,"SEWSAmbientTemp_C_Avg","Temperature ambient","C","C",1.0,0.0,"","avg","OTHER",2218,"","temperature_ambient_o_2218"]
[4903,82742,"SEWSModuleTemp_C_Avg","Temperature module","C","C",1.0,0.0,"","avg","OTHER",2218,"","temperature_module_o_2218"]
[4903,82765,"ShuntCurrent_A_Avg_1","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_1__82765"]
[4903,82766,"ShuntCurrent_A_Avg_2","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_2__82766"]
[4903,82767,"ShuntCurrent_A_Avg_3","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_3__82767"]
[4903,82768,"ShuntCurrent_A_Avg_4","DC current other","A","A",1.0,0.0,"","avg","",null,"","shuntcurrent_a_avg_4__82768"]
[4903,82773,"ShuntEtot_kWh_Max_1","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_1__82773"]
[4903,82774,"ShuntEtot_kWh_Max_2","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_2__82774"]
[4903,82775,"ShuntEtot_kWh_Max_3","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_3__82775"]
[4903,82776,"ShuntEtot_kWh_Max_4","DC energy other","kWh","kWh",1.0,0.0,"","max","",null,"","shuntetot_kwh_max_4__82776"]
[4903,82769,"ShuntPDC_kW_Avg_1","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_1__82769"]
[4903,82770,"ShuntPDC_kW_Avg_2","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_2__82770"]
[4903,82771,"ShuntPDC_kW_Avg_3","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_3__82771"]
[4903,82772,"ShuntPDC_kW_Avg_4","DC power other","kW","kW",1.0,0.0,"","avg","",null,"","shuntpdc_kw_avg_4__82772"]
[4903,82798,"TCTemps_C_Avg_1","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_1__82798"]
[4903,82807,"TCTemps_C_Avg_10","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_10__82807"]
[4903,82808,"TCTemps_C_Avg_11","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_11__82808"]
[4903,82809,"TCTemps_C_Avg_12","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_12__82809"]
[4903,82799,"TCTemps_C_Avg_2","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_2__82799"]
[4903,82800,"TCTemps_C_Avg_3","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_3__82800"]
[4903,82801,"TCTemps_C_Avg_4","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_4__82801"]
[4903,82802,"TCTemps_C_Avg_5","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_5__82802"]
[4903,82803,"TCTemps_C_Avg_6","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_6__82803"]
[4903,82804,"TCTemps_C_Avg_7","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_7__82804"]
[4903,82805,"TCTemps_C_Avg_8","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_8__82805"]
[4903,82806,"TCTemps_C_Avg_9","Temperature other","C","C",1.0,0.0,"","avg","OTHER",null,"","tctemps_c_avg_9__82806"]
[4903,82709,"TemperatureFaults_Max","Temperature other","-","-",1.0,0.0,"","max","INVERTER",14539,"","temperature_other_inv_14539"]
[4903,82782,"WindHeatStateID_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2218,"","wind_other_o_2218_2"]
[4903,82781,"WindRef_V_Min","AC other","V","V",1.0,0.0,"","min","OTHER",2218,"","wind_other_o_2218_3"]
[4903,82780,"WindSpeed_ms_Max","AC other","m/s","m/s",1.0,0.0,"","max","OTHER",2218,"","wind_speed_o_2218_2"]
[4903,82783,"WindValid_Avg","AC other","-","-",1.0,0.0,"","avg","OTHER",2218,"","wind_other_o_2218_4"]
[4903,82706,"DPCBFaults_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539"]
[4903,82690,"DoorOpen_Min","System other","-","-",1.0,0.0,"","min","",null,"","dooropen_min__82690"]
[4903,82704,"GeneralFaults1_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_2"]
[4903,82705,"GeneralFaults2_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_3"]
[4903,82707,"HardwareFaults_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_4"]
[4903,82736,"InvFreq_Avg","System other","Hz","Hz",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_5"]
[4903,82732,"InvGndImped_kOhm_Avg","System other","kOhm","kOhm",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_6"]
[4903,82714,"InvIDCin_Avg","System other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_7"]
[4903,82715,"InvIGnd_Avg","System other","A","A",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_8"]
[4903,82737,"InvOpState_Avg","System other","-","-",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_9"]
[4903,82703,"InvVDVoltage_V_Avg","System other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_10"]
[4903,82712,"InvVPVIn_Avg","System other","V","V",1.0,0.0,"","avg","INVERTER",14539,"","system_other_inv_14539_11"]
[4903,82708,"InverterFaults_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_12"]
[4903,82786,"Load_A_Avg","System other","A","A",1.0,0.0,"","avg","",null,"","load_a_avg__82786"]
[4903,82711,"NumActiveFaults_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_13"]
[4903,82744,"PwrMtrIa_Avg","System other","A","A",1.0,0.0,"","avg","METER",1865,"","system_other_meter_1865"]
[4903,82745,"PwrMtrIb_Avg","System other","A","A",1.0,0.0,"","avg","METER",1865,"","system_other_meter_1865_2"]
[4903,82746,"PwrMtrIc_Avg","System other","A","A",1.0,0.0,"","avg","METER",1865,"","system_other_meter_1865_3"]
[4903,82790,"Qloss_Ah_Max","System other","Ah","Ah",1.0,0.0,"","max","",null,"","qloss_ah_max__82790"]
[4903,82743,"SEWSPOAIrrad_Wm2_Avg","System other","W/m^2","W/m^2",1.0,0.0,"","avg","OTHER",2218,"","system_other_o_2218"]
[4903,82710,"Warnings_Max","System other","-","-",1.0,0.0,"","max","INVERTER",14539,"","system_other_inv_14539_14"]
[4903,82778,"WindDirAve_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2218,"","wind_direction_o_2218"]
[4903,82779,"WindDirStdDev_deg","AC other","Deg","Deg",1.0,0.0,"","wvc","OTHER",2218,"","wind_other_o_2218"]
[4903,82777,"WindSpeedAve_ms","AC other","m/s","m/s",1.0,0.0,"","wvc","OTHER",2218,"","wind_speed_o_2218"]