← ALL CHALLENGES
CHALLENGE / BEGINNER / READY TO QUERY

Which AI data-center milestones are still in the future?

Practice CASE, CURRENT_DATE and JOIN with Epoch AI site milestones and capacity estimates.

01 / THE QUESTION

Question

Which milestones in Epoch AI's timeline are dated after today? Label each milestone using the query's current date, then compare the IT power estimates and countries of the sites involved.

02 / SOURCE TABLES

Tables to use

03 / RELATIONSHIP

ER diagram

ONE TO MANY RELATIONSHIP
epoch_ai_data_centersdata_centerKey fieldcountrycurrent_it_power_mw
epoch_ai_data_center_timelinesdata_centerJoin fielddateit_power_mwconstruction_status

epoch_ai_data_centers.data_center = epoch_ai_data_center_timelines.data_center · one site to many dated milestones

04 / ANALYST GUIDE

Guide

Analysis requirements

  • Join epoch_ai_data_center_timelines to epoch_ai_data_centers on data_center.
  • Use CURRENT_DATE and CASE to label future versus on_or_before_today. Do not hard-code today's date.
  • A past date does not prove that an estimated event occurred. Explain that distinction in your findings.
  • it_power_mw is IT power capacity; facility_power_mw also includes cooling and facility overhead. Neither is electricity consumption.
  • Each row is a milestone snapshot. Do not sum capacities across dates or sum repeated current_h100_equivalents lookups.
  • The export contains selected sites, not all AI data centers. A 2030 milestone for one site does not make this a complete projection through 2030.

Suggested query

Expand suggested query
SQL / STARTER QUERY
SELECT
  t.data_center,
  s.country,
  t.date,
  CASE
    WHEN CAST(t.date AS DATE) > CURRENT_DATE THEN 'future'
    ELSE 'on_or_before_today'
  END AS date_label,
  t.it_power_mw,
  t.construction_status
FROM epoch_ai_data_center_timelines AS t
JOIN epoch_ai_data_centers AS s USING (data_center)
ORDER BY t.date DESC, t.data_center
LIMIT 30;