Energy System & Market Monitoring Accelerator

$1490

Real-time power-system monitoring from TSO open APIs: grid frequency, reserve markets, generation mix, and staleness alerting with configurable series IDs for any European TSO. Ships a dependency-free monitoring library + offline tests. Fully generic Databricks Asset Bundle.

📁 18 files🏷 v1.0.0

Production-readyUnit-testedDatabricks Asset Bundle

✓ Instant download✓ Lifetime updates✓ MIT licensed✓ Secure checkout (Stripe)

⚙ Try the Live Demo interactive

Watch a live grid-frequency gauge around 50 Hz with normal/warning/critical status and reserve adequacy — the accelerator's monitoring logic.

⚡ Open Frequency Monitor

📋 What's Inside 18 files

✓ README.md
✓ LICENSE
✓ manifest.json
✓ databricks.yml
✓ resources/jobs.yml
✓ src/series_config.example.sql
✓ src/01_ingest_tso_events.sql
✓ src/02_api_health.sql
✓ src/03_frequency_monitoring.sql
✓ src/04_generation_mix.sql
✓ lib/grid_health.py
✓ tests/test_grid_health.py
✓ conftest.py
✓ guide/01_what-you-get.md
✓ guide/02_getting-started.md
✓ guide/03_architecture.md
✓ guide/04_support.md
✓ guides/energy-monitoring-methodology.md

📁 File Structure 18 files

market-monitoring-accelerator/
├── README.md
├── LICENSE
├── manifest.json
├── databricks.yml
├── resources/
│   ├── jobs.yml
├── src/
│   ├── series_config.example.sql
│   ├── 01_ingest_tso_events.sql
│   ├── 02_api_health.sql
│   ├── 03_frequency_monitoring.sql
│   ├── 04_generation_mix.sql
├── lib/
│   ├── grid_health.py
├── tests/
│   ├── test_grid_health.py
├── conftest.py
├── guide/
│   ├── 01_what-you-get.md
│   ├── 02_getting-started.md
│   ├── 03_architecture.md
│   ├── 04_support.md
├── guides/
│   ├── energy-monitoring-methodology.md

📖 Documentation Preview README excerpt

Energy System & Market Monitoring Accelerator

Real-time **power-system monitoring** from TSO open APIs: grid frequency,

reserve-market procurement, generation mix, consumption vs production balance,

and data-freshness alerting. Situational awareness for trading desks and control

rooms — replaces manual TSO-website checking.

Fully generic: **configurable series IDs** map any European TSO's open API

(e.g. ENTSO-E Transparency Platform and national TSO open APIs) to logical names. No org-specific

dependencies.

What's inside

- **Databricks Asset Bundle** — a 3-minute ingest + health job.

- **Series-config mapping** — one editable table maps TSO series IDs to logical

names (frequency, production, consumption, wind, reserves).

- **Monitoring SQL** — API freshness/health, grid frequency with 50 Hz status,

and generation mix.

- **A dependency-free monitoring library** (`lib/grid_health.py`) — frequency

classification, staleness health, reserve adequacy, generation mix, and

balance status — with an offline test suite (5 tests).

Quickstart

```bash

pip install pytest && pytest tests/ -v # validate monitoring logic offline

databricks bundle deploy -t dev -p <profile>

```

Point the ingestion at your TSO API into `<catalog>.<schema>.tso_events` and set

your series IDs in `series_config` (see `guide/03_architecture.md`).

License

MIT — see `LICENSE`.

... preview truncated, see full README in product download.

📄 Code Sample .sql preview

src/series_config.example.sql-- Energy System Monitoring: Series ID configuration -- Map your TSO's open-API series IDs to logical names. Copy to series_config.sql -- and edit. Example IDs shown are illustrative — set your TSO's real IDs. CREATE OR REPLACE TABLE IDENTIFIER(:catalog || '.' || :schema || '.series_config') AS SELECT * FROM VALUES (177, 'grid_frequency_hz'), (74, 'total_production_mw'), (124, 'total_consumption_mw'), (75, 'wind_generation_mw'), (247, 'solar_forecast_mw'), (281, 'fcr_n_procured_mw'), (315, 'fcr_d_up_procured_mw') AS t(series_id, logical_name);

Buy Now — $1490 ⚙ Open Frequency Monitor Back to Products