steampipe plugin install ellisvalentiner/weatherkitsteampipe plugin install ellisvalentiner/weatherkit

weatherkit_availability weatherkit_current_weather weatherkit_daily_forecast weatherkit_daily_forecast_weather weatherkit_hourly_forecast weatherkit_hourly_forecast_weather weatherkit_next_hour_forecast weatherkit_next_hour_forecast_weather weatherkit_weather_alert

Table: weatherkit_hourly_forecast

Get the hourly forecast for the specified location.

The weatherkit_hourly_forecast table can be used to query the hourly forecast for the requested location. You must specify location in the where or join clause using the latitude and longitude columns.

Examples

Get the hourly forecast for Ann Arbor, MI

select
  *
from
  weatherkit_hourly_forecast
where
  latitude = '42.281'
  and longitude = '-83.743';

Get the hourly precipitation forecast

select
  forecast_start,
  precipitation_amount,
  precipitation_chance,
  precipitation_type
from
  weatherkit_hourly_forecast
where
  latitude = '42.281'
  and longitude = '-83.743'
order by
  forecast_start;

Get the hourly wind direction, guest, and speed

select
  forecast_start,
  wind_direction,
  wind_gust,
  wind_speed
from
  weatherkit_hourly_forecast
where
  latitude = '42.281'
  and longitude = '-83.743'
order by
  forecast_start;

Get the hourly pressure change

select
  forecast_start,
  pressure - lag(pressure) over (
    order by
      forecast_start
  ) as pressure_change
from
  weatherkit_hourly_forecast
where
  latitude = '42.281'
  and longitude = '-83.743'
order by
  forecast_start;