Line Rating Weather Validation

Daily, leakage-safe validation of the forecast weather used by the modeled line-rating experiment.

Ask the GridWeather data
Native record
validation run x forecast lead x forecast source
daily validation run publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · validation_end

Overview

Each run scores fixed forecast lead times against realized public station temperatures, records temperature and rating-error metrics, and declares whether a lead band passes the release gate. The table contains aggregate validation results only: it does not retain station rows, operator facility ratings, restricted records, or line-level benchmark data.

Query contract

Use one completed non-dry-run validation run and preserve its separate lead_hours rows. For release decisions, select the latest run available before the forecast materialization began.

Analysis rules

  • Do not pool lead-hour error metrics without weighting by sample_count and preserving the release decision for each lead band.
  • Treat meets_release_gate as a model-governance decision, not as proof that every line-hour estimate is accurate.

Related analysis

  • temperature guardband and weather release gate · Select the latest passing validation run by model_version and forecast lead before forecast_as_of.

Interpretation

  • Metrics are aggregate weather and modeled-rating errors; this table contains no line-level operator rating benchmark.
  • The validation gate controls whether a weather lead band may be used, not whether a physical facility has additional transfer capacity.

Access

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema25

Column
Type
run_timeDateTime64(6, 'UTC')
run_idString
model_versionLowCardinality(String)
validation_startDateTime64(6, 'UTC')
validation_endDateTime64(6, 'UTC')
lead_hoursInt32
forecast_sourceLowCardinality(String)
sample_countInt64
coverage_sample_countInt64
calibration_sample_countInt64
temperature_guardband_cNullable(Float64)
unadjusted_temperature_mae_cNullable(Float64)
temperature_mae_cNullable(Float64)
temperature_p95_absolute_error_cNullable(Float64)
temperature_bias_cNullable(Float64)
temperature_within_2c_fractionNullable(Float64)
rating_mae_pct_pointsNullable(Float64)
rating_p95_absolute_error_pct_pointsNullable(Float64)
rating_overstatement_above_5pt_fractionNullable(Float64)
benchmark_temperature_mae_cNullable(Float64)
temperature_mae_improvement_fractionNullable(Float64)
beats_ercot_temperature_maeNullable(Bool)
meets_release_gateNullable(Bool)
dry_runBool
ingested_atDateTime64(6, 'UTC')

Sample data

run_timerun_idmodel_versionvalidation_startvalidation_endlead_hoursforecast_sourcesample_countcoverage_sample_countcalibration_sample_counttemperature_guardband_cunadjusted_temperature_mae_ctemperature_mae_ctemperature_p95_absolute_error_ctemperature_bias_ctemperature_within_2c_fractionrating_mae_pct_pointsrating_p95_absolute_error_pct_pointsrating_overstatement_above_5pt_fractionbenchmark_temperature_mae_ctemperature_mae_improvement_fractionbeats_ercot_temperature_maemeets_release_gatedry_runingested_at
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000048route_weather656187747171.552.7274988438055611.97311086266989944.434841240776921-0.73817802160410620.55335365853658540.15763521835291.22306409756169902.4554115853658540.19642357540806832truetruefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000048ercot_zone_weather6566564717∅∅2.4554115853658545.8888888888888891.71430386178861770.49695121951219510.408516180001898432.5889476118998720∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000036route_weather386995532707412.77673774632252532.0817916493697664.680206298828102-1.4692643056337790.52752649263375550.105492964932688930.56238842531839420.00025846471956577931.958336923121105-0.06304059571726024falsefalsefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000036ercot_zone_weather3869386927074∅∅1.9583369231211055.3333333333333320.9313273599264810.61876453864047550.27536620538315172.39713169165711730∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000024route_weather38699553270740.832.2636663606092011.89654708410513084.521251220703104-0.91153924462561720.59421039028172650.102149060363874250.676618129508632601.92834783607593120.016491190736373014truetruefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000024ercot_zone_weather3869386927074∅∅1.92834783607593125.11111111111111250.29008357025932610.62109072111656760.200859306190738361.82397636519153750.0005169294391315585∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000012route_weather38699553270740.511.44835217575774071.34802435472583083.4068139648437743-0.143444761572723120.76298785215818040.114224741847758520.82183671787501301.9128614916286150.2952838662782011truetruefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.00000012ercot_zone_weather3869386927074∅∅1.9128614916286155.1111111111111120.248363056776083090.62987852158180410.198979372990111151.95104873823077620.0005169294391315585∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.0000006route_weather38699553270740.341.15183090306804231.13176515813828532.97714531792537240.061288935069567910.84414577410183510.096028326741539370.583019710460184101.8927586801068320.40205522762447155truetruefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.0000006ercot_zone_weather3869386927074∅∅1.89275868010683250.23839780592171360.63298009821659340.1707441101770121.40715207888744140.0005169294391315585∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.0000001route_weather386995532707400.87236956828651190.87236956828651192.2358630371093793-0.115793753679509820.92866373739984490.063238632071835710.3091237606572145301.8940510037046610.5394160101390066truetruefalse2026-10-17 09:51:16.106131
2026-10-17 09:46:52.221607bafaf61d-8658-4171-865d-1411feb283fbieee738-hrrr-v32026-10-16 06:00:00.0000002026-10-17 06:00:00.0000001ercot_zone_weather3869386927074∅∅1.8940510037046615.1111111111111110.31523362338818510.63220470405789610.1707441101770121.40715207888744140.0005169294391315585∅∅∅∅false2026-10-17 09:51:16.106131
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000048route_weather683156347271.031.5299636227688511.5476127308513114.2856762695312690.65596177584723580.73352855051244510.95813589053669293.77625828780777440.00292825768667642761.92825768667642760.19740357238310904truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000048ercot_zone_weather6836834727∅∅1.92825768667642765.533333333333330.48535871156661780.65592972181551981.20163233596496234.1633654932644330.007320644216691069∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000036route_weather38948898271470.741.5089051787238081.5244370454773994.129996663411450.47676819499006570.74216743708269130.92827463767673733.13267027303358250.00359527478171545962.0028034583119330.23884840564322077truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000036ercot_zone_weather3894389427147∅∅2.0028034583119335.8708333333333290.3324131141927750.64021571648690291.11602895728109423.88788347014306850.009758602978941962∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000024route_weather38948898271470.821.44273494595718391.43707607459772073.76595241970483750.4622719607021180.75166923472008220.90439877421920933.140260984492630.0048793014894709812.03766478342749520.29474362697653445truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000024ercot_zone_weather3894389427147∅∅2.03766478342749525.9083333333333280.2934429036123950.62378017462763221.13590634260229554.0724883172292840.01386748844375963∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000012route_weather38948898271470.671.24100698662533481.3502700286501333.5602423434787580.67889096870984280.78299948638931690.82290268317333952.84530196921175540.00256805341551104252.03921274895851170.3378473975607708truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.00000012ercot_zone_weather3894389427147∅∅2.03921274895851175.8333333333333320.29133852650801780.60708782742681041.16473761070900064.1699289382812980.014637904468412942∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.0000006route_weather38948898271470.311.15817025002909221.20322100391550653.2207098049587890.47254836869814780.82614278376990250.75326955341095332.7107855193747130.00179763739085772981.95024396507447360.38304077568594896truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.0000006ercot_zone_weather3894389427147∅∅1.95024396507447365.78750000000000050.40451834731495720.6355932203389831.06356199679257733.8539683600405690.01078582434514638∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.0000001route_weather389488982714700.92750432613620690.92750432613620692.53856018066406940.0009241714656276790.90010272213662050.60503886774015852.335109223288670.0010272213662044171.93553472578896320.5208020224188242truetruefalse2026-10-16 09:51:17.329846
2026-10-16 09:46:53.5288328a73f437-e1d3-4683-a93f-9819d7bcbdfcieee738-hrrr-v32026-10-15 06:00:00.0000002026-10-16 06:00:00.0000001ercot_zone_weather3894389427147∅∅1.93553472578896325.8055555555555570.480946470353249830.64458140729327171.06452746093824623.8485621132373860.011042629686697484∅∅∅∅false2026-10-16 09:51:17.329846
2026-10-15 09:46:50.48739367ec9cab-bf6e-4cd4-816a-a3ce2a59cbf5ieee738-hrrr-v32026-10-14 06:00:00.0000002026-10-15 06:00:00.00000048route_weather687195246590.671.62614475616103071.25840283700644953.517936740451365-0.58546736799740810.8267831149927221.22266225393626823.24175139833822050.0131004366812227071.5045285460132620.1635899230087742truefalsefalse2026-10-15 09:51:27.738882

Coverage

100.0% complete0 gap days48 days with data
Show coverage history
Coverage: 100.0%Days with data: 48Gaps: 0
2026
gaplessmore