府県予報区ごとの週間天気予報です。7 日分の天気・降水確率・信頼度を区域 × 日ごとに持ちます。
SELECT office_code, CAST(report_datetime AS "TIMESTAMP WITH TIME ZONE") AS report_datetime, area_code, area_name, CAST("left"(forecast_datetime, 10) AS "DATE") AS forecast_date, weather_code, TRY_CAST("nullif"(pop, '') AS INTEGER) AS pop_pct, "nullif"(reliability, '') AS reliability FROM {DUCKLAKE_CATALOG}.main.raw_jma_weekly_forecasts