{"queries":[{"id":"days","compiledQueryString":"select\n tradingDay\nfrom networkrisk_days","inputQueryString":"select\n tradingDay\nfrom networkrisk_days","compiled":false,"inline":true},{"id":"consq","compiledQueryString":"select networkContingency\nfrom networkrisk_facility\nwhere tradingDay >= DATE '${inputs.mydaterange.start}'\n and tradingDay < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\ngroup by 1","inputQueryString":"select networkContingency\nfrom networkrisk_facility\nwhere tradingDay >= DATE '${inputs.mydaterange.start}'\n and tradingDay < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\ngroup by 1","compiled":false,"inline":true},{"id":"facsq","compiledQueryString":"select facilityCode from networkrisk_facility\nwhere tradingDay >= DATE '${inputs.mydaterange.start}'\nand tradingDay < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\nGROUP BY 1","inputQueryString":"select facilityCode from networkrisk_facility\nwhere tradingDay >= DATE '${inputs.mydaterange.start}'\nand tradingDay < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\nGROUP BY 1","compiled":false,"inline":true},{"id":"riskvalue","compiledQueryString":"select\n date_trunc('hour',dispatchInterval) dispatchInterval,\n networkContingency,\n facilityCode,\n APPROX_QUANTILE(networkRiskValue,0.5) networkRiskValue\n from networkrisk_all\n where facilityCode = '${inputs.facdrop.value}'\n and dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2,3\n order by dispatchInterval","inputQueryString":"select\n date_trunc('hour',dispatchInterval) dispatchInterval,\n networkContingency,\n facilityCode,\n APPROX_QUANTILE(networkRiskValue,0.5) networkRiskValue\n from networkrisk_all\n where facilityCode = '${inputs.facdrop.value}'\n and dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2,3\n order by dispatchInterval","compiled":false,"inline":true},{"id":"riskvalueByContingency","compiledQueryString":"select\n DATE_TRUNC('hour',dispatchInterval) dispatchInterval,\n networkContingency,\n facilityCode,\n APPROX_QUANTILE(networkRiskValue,0.5) networkRiskValue\n from networkrisk_all\n where networkContingency='${inputs.cons.value}'\n and dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2,3\n order by dispatchInterval","inputQueryString":"select\n DATE_TRUNC('hour',dispatchInterval) dispatchInterval,\n networkContingency,\n facilityCode,\n APPROX_QUANTILE(networkRiskValue,0.5) networkRiskValue\n from networkrisk_all\n where networkContingency='${inputs.cons.value}'\n and dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2,3\n order by dispatchInterval","compiled":false,"inline":true},{"id":"contingencyHeatmap","compiledQueryString":"SELECT\n CAST(date_trunc('day',dispatchInterval) as varchar) dispatchInterval,\n networkContingency,\n MAX(networkRiskValue) networkRiskValue\n FROM networkrisk_all\n WHERE dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2\n order by dispatchInterval,networkContingency","inputQueryString":"SELECT\n CAST(date_trunc('day',dispatchInterval) as varchar) dispatchInterval,\n networkContingency,\n MAX(networkRiskValue) networkRiskValue\n FROM networkrisk_all\n WHERE dispatchInterval >= DATE '${inputs.mydaterange.start}'\n and dispatchInterval < DATE '${inputs.mydaterange.end}' + INTERVAL '1' day\n GROUP BY 1,2\n order by dispatchInterval,networkContingency","compiled":false,"inline":true}]}

Network Risk Calculations

By Facility

By Contingency

Contingency Overview