{"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":40,"rows_kept":40,"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":[]}
[1202,2810,"inv1_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv1_ac_power__2810"]
[1202,2811,"inv1_dc_power","DC power","W","W",1.0,0.0,"inv1_dc_voltage*inv1_dc_current","avg",null,null,"","inv1_dc_power__2811"]
[1202,2815,"inv2_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv2_ac_power__2815"]
[1202,2816,"inv2_dc_power","DC power","W","W",1.0,0.0,"inv2_dc_voltage*inv2_dc_current","avg",null,null,"","inv2_dc_power__2816"]
[1202,2820,"inv3_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv3_ac_power__2820"]
[1202,2821,"inv3_dc_power","DC power","W","W",1.0,0.0,"inv3_dc_voltage*inv3_dc_current","avg",null,null,"","inv3_dc_power__2821"]
[1202,2825,"inv4_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv4_ac_power__2825"]
[1202,2826,"inv4_dc_power","DC power","W","W",1.0,0.0,"inv4_dc_voltage*inv4_dc_current","avg",null,null,"","inv4_dc_power__2826"]
[1202,2830,"inv5_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv5_ac_power__2830"]
[1202,2831,"inv5_dc_power","DC power","W","W",1.0,0.0,"inv5_dc_voltage*inv5_dc_current","avg",null,null,"","inv5_dc_power__2831"]
[1202,2835,"inv6_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv6_ac_power__2835"]
[1202,2836,"inv6_dc_power","DC power","W","W",1.0,0.0,"inv6_dc_voltage*inv6_dc_current","avg",null,null,"","inv6_dc_power__2836"]
[1202,2840,"ac_power","AC power","W","W",1.0,0.0,"inv1_ac_power+inv2_ac_power+inv3_ac_power+inv4_ac_power+inv5_ac_power+inv6_ac_power","avg",null,null,"","ac_power__2840"]
[1202,2841,"dc_power","DC power","W","W",1.0,0.0,"inv1_dc_power+inv2_dc_power+inv3_dc_power+inv4_dc_power+inv5_dc_power+inv6_dc_power","avg",null,null,"","dc_power__2841"]
[1202,2804,"ac_current","AC current","A","A",1.0,0.0,"","avg",null,null,"","ac_current__2804"]
[1202,2813,"inv1_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv1_dc_current__2813"]
[1202,2818,"inv2_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv2_dc_current__2818"]
[1202,2823,"inv3_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv3_dc_current__2823"]
[1202,2828,"inv4_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv4_dc_current__2828"]
[1202,2833,"inv5_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv5_dc_current__2833"]
[1202,2838,"inv6_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv6_dc_current__2838"]
[1202,2802,"ac_power_metered_kW","AC power","kW","W",1000.0,0.0,"","avg",null,null,"","ac_power_metered_kw__2802"]
[1202,2803,"ac_voltage","AC voltage","V","V",1.0,0.0,"","avg",null,null,"","ac_voltage__2803"]
[1202,2806,"poa_irradiance","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","poa_irradiance__2806"]
[1202,2808,"module_temp_K","Temperature module","C","C",1.0,-273.15,"","avg",null,null,"","module_temp_k__2808"]
[1202,2807,"ambient_temp_K","Temperature ambient","C","C",1.0,-273.15,"","avg",null,null,"","ambient_temp_k__2807"]
[1202,2814,"inv1_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv1_temp__2814"]
[1202,2819,"inv2_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv2_temp__2819"]
[1202,2824,"inv3_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv3_temp__2824"]
[1202,2829,"inv4_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv4_temp__2829"]
[1202,2834,"inv5_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv5_temp__2834"]
[1202,2839,"inv6_temp","Temperature inverter","C","C",1.0,0.0,"","avg",null,null,"","inv6_temp__2839"]
[1202,2812,"inv1_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv1_dc_voltage__2812"]
[1202,2817,"inv2_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv2_dc_voltage__2817"]
[1202,2822,"inv3_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv3_dc_voltage__2822"]
[1202,2827,"inv4_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv4_dc_voltage__2827"]
[1202,2832,"inv5_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv5_dc_voltage__2832"]
[1202,2837,"inv6_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv6_dc_voltage__2837"]
[1202,2805,"power_factor","AC other","-","-",1.0,0.0,"",null,null,null,"","power_factor__2805"]
[1202,2809,"wind_speed","Wind speed","m/s","m/s",1.0,0.0,"","median",null,null,"","wind_speed__2809"]