← Back to all products

Energy System & Market Monitoring Accelerator

$1490

Real-time power-system monitoring from TSO open APIs: grid frequency, reserve markets, generation mix, and staleness alerting. Configurable series IDs for any European TSO.

18 filesv1.0.0
PythonMarkdownSQLYAMLJSONDatabricks

Product Preview

Try the interactive reader and demo tools below, or get the full product with all content unlocked.

⚙ Try Demo Tools

File Structure 18 files

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

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


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.

Code Sample .py preview

conftest.py import os,sys sys.path.insert(0, os.path.dirname(__file__))