Energy Net Metering ETL

API
SourceOpen Data API
Python
ETLPython
BigQuery
WarehouseBigQuery
Looker
BI LayerLooker Studio

Pipeline Explorer

Click a step

Extract: call EIA endpoint with params

# etl_fetch.py (excerpt)
URL = "https://api.eia.gov/v2/electricity/state-electricity-profiles/net-metering/data/"

params = {
  "api_key": API_KEY,
  "frequency": "annual",
  "data[0]": "capacity",
  "data[1]": "customers",
  "sort[0][column]": "period",
  "sort[0][direction]": "desc",
  "offset": 0,
  "length": 5000
}

r = requests.get(URL, params=params, timeout=30)
records = r.json()["response"]["data"]

Source API Configuration

EIA API configuration screenshot

BigQuery Load

EIA BigQuery load screenshot

Dashboard (Looker Studio)

Embedded