{"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":42,"rows_kept":42,"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":[]}
[1204,2916,"inv1_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv1_ac_power__2916"]
[1204,2917,"inv1_dc_power","DC power","W","W",1.0,0.0,"inv1_dc_voltage*inv1_dc_current","avg",null,null,"","inv1_dc_power__2917"]
[1204,2920,"inv2_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv2_ac_power__2920"]
[1204,2921,"inv2_dc_power","DC power","W","W",1.0,0.0,"inv2_dc_voltage*inv2_dc_current","avg",null,null,"","inv2_dc_power__2921"]
[1204,2924,"inv3_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv3_ac_power__2924"]
[1204,2925,"inv3_dc_power","DC power","W","W",1.0,0.0,"inv3_dc_voltage*inv3_dc_current","avg",null,null,"","inv3_dc_power__2925"]
[1204,2928,"inv4_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv4_ac_power__2928"]
[1204,2929,"inv4_dc_power","DC power","W","W",1.0,0.0,"inv4_dc_voltage*inv4_dc_current","avg",null,null,"","inv4_dc_power__2929"]
[1204,2932,"inv5_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv5_ac_power__2932"]
[1204,2933,"inv5_dc_power","DC power","W","W",1.0,0.0,"inv5_dc_voltage*inv5_dc_current","avg",null,null,"","inv5_dc_power__2933"]
[1204,2936,"inv6_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv6_ac_power__2936"]
[1204,2937,"inv6_dc_power","DC power","W","W",1.0,0.0,"inv6_dc_voltage*inv6_dc_current","avg",null,null,"","inv6_dc_power__2937"]
[1204,2940,"inv7_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv7_ac_power__2940"]
[1204,2941,"inv7_dc_power","DC power","W","W",1.0,0.0,"inv7_dc_voltage*inv7_dc_current","avg",null,null,"","inv7_dc_power__2941"]
[1204,2944,"inv8_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv8_ac_power__2944"]
[1204,2945,"inv8_dc_power","DC power","W","W",1.0,0.0,"inv8_dc_voltage*inv8_dc_current","avg",null,null,"","inv8_dc_power__2945"]
[1204,2948,"inv9_ac_power","AC power","W","W",1.0,0.0,"","avg",null,null,"","inv9_ac_power__2948"]
[1204,2949,"inv9_dc_power","DC power","W","W",1.0,0.0,"inv9_dc_voltage*inv9_dc_current","avg",null,null,"","inv9_dc_power__2949"]
[1204,2952,"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+inv7_ac_power+inv8_ac_power+inv9_ac_power","avg",null,null,"","ac_power__2952"]
[1204,2953,"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+inv7_dc_power+inv8_dc_power+inv9_dc_power","avg",null,null,"","dc_power__2953"]
[1204,2919,"inv1_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv1_dc_current__2919"]
[1204,2923,"inv2_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv2_dc_current__2923"]
[1204,2927,"inv3_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv3_dc_current__2927"]
[1204,2931,"inv4_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv4_dc_current__2931"]
[1204,2935,"inv5_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv5_dc_current__2935"]
[1204,2939,"inv6_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv6_dc_current__2939"]
[1204,2943,"inv7_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv7_dc_current__2943"]
[1204,2947,"inv8_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv8_dc_current__2947"]
[1204,2951,"inv9_dc_current","DC current","A","A",1.0,0.0,"","avg",null,null,"","inv9_dc_current__2951"]
[1204,2912,"poa_irradiance","Irradiance POA","W/m^2","W/m^2",1.0,0.0,"","avg",null,null,"","poa_irradiance__2912"]
[1204,2914,"module_temp","Temperature module","C","C",1.0,0.0,"","avg",null,null,"","module_temp__2914"]
[1204,2913,"ambient_temp","Temperature ambient","C","C",1.0,0.0,"","avg",null,null,"","ambient_temp__2913"]
[1204,2918,"inv1_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv1_dc_voltage__2918"]
[1204,2922,"inv2_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv2_dc_voltage__2922"]
[1204,2926,"inv3_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv3_dc_voltage__2926"]
[1204,2930,"inv4_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv4_dc_voltage__2930"]
[1204,2934,"inv5_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv5_dc_voltage__2934"]
[1204,2938,"inv6_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv6_dc_voltage__2938"]
[1204,2942,"inv7_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv7_dc_voltage__2942"]
[1204,2946,"inv8_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv8_dc_voltage__2946"]
[1204,2950,"inv9_dc_voltage","DC voltage","V","V",1.0,0.0,"","avg",null,null,"","inv9_dc_voltage__2950"]
[1204,2915,"wind_speed_mph","Wind speed","m/s","m/s",0.44704,0.0,"","median",null,null,"","wind_speed_mph__2915"]