WeatherAPI
W
WeatherAPI

tap-weatherapi (meltanolabs variant)

WeatherAPI is a weather data provider offering current conditions, forecasts, and historical weather data for any location worldwide. It supports queries by city name, US zip code, UK postcode, latitude/longitude pairs, IP address, and more.

The tap-weatherapi extractor connects to the WeatherAPI REST API to sync weather data for one or more configured locations into your data warehouse.

Prerequisites

Obtain a free or paid API key from the WeatherAPI dashboard and set it as the API Key setting.

Available Streams

forecast

Daily forecast data for each configured location. Each record represents one forecast day per location. Synced as a full-table refresh (no replication key).

FieldDescription
locationThe query string used (zip, city, lat/lon, …) — primary key
dateCalendar date (YYYY-MM-DD) — primary key
custom_idA custom identifier for the location
date_epochUnix epoch timestamp for the date
location_nameResolved location name
location_regionRegion or state of the location
location_countryCountry of the location
location_latLatitude of the location
location_lonLongitude of the location
location_tz_idTime zone identifier
maxtemp_cMaximum temperature in Celsius
maxtemp_fMaximum temperature in Fahrenheit
mintemp_cMinimum temperature in Celsius
mintemp_fMinimum temperature in Fahrenheit
avgtemp_cAverage temperature in Celsius
avgtemp_fAverage temperature in Fahrenheit
maxwind_mphMaximum wind speed in mph
maxwind_kphMaximum wind speed in kph
totalprecip_mmTotal precipitation in mm
totalprecip_inTotal precipitation in inches
totalsnow_cmTotal snowfall in cm
avgvis_kmAverage visibility in km
avgvis_milesAverage visibility in miles
avghumidityAverage humidity percentage
daily_will_it_rainWhether it will rain (1 = yes, 0 = no)
daily_chance_of_rainPercentage chance of rain
daily_will_it_snowWhether it will snow (1 = yes, 0 = no)
daily_chance_of_snowPercentage chance of snow
conditionWeather condition object with text description, icon URL, and condition code
uvUV index
sunriseSunrise time
sunsetSunset time
moonriseMoonrise time
moonsetMoonset time
moon_phaseMoon phase description
moon_illuminationMoon illumination percentage
hourArray of hourly weather data objects (see hourly fields below)

Hourly fields (each item in the hour array):

FieldDescription
time_epochUnix epoch for the hour
timeLocal date and time for the hour
temp_cTemperature in Celsius
temp_fTemperature in Fahrenheit
is_dayWhether it is daytime (1 = yes, 0 = no)
conditionWeather condition object (text, icon, code)
wind_mphWind speed in mph
wind_kphWind speed in kph
wind_degreeWind direction in degrees
wind_dirWind direction as compass bearing (e.g. NNE)
pressure_mbAtmospheric pressure in millibars
pressure_inAtmospheric pressure in inches
precip_mmPrecipitation in mm
precip_inPrecipitation in inches
snow_cmSnowfall in cm
humidityHumidity percentage
cloudCloud cover percentage
feelslike_cFeels-like temperature in Celsius
feelslike_fFeels-like temperature in Fahrenheit
windchill_cWind chill in Celsius
windchill_fWind chill in Fahrenheit
heatindex_cHeat index in Celsius
heatindex_fHeat index in Fahrenheit
dewpoint_cDew point in Celsius
dewpoint_fDew point in Fahrenheit
will_it_rainWhether it will rain this hour (1 = yes, 0 = no)
chance_of_rainPercentage chance of rain this hour
will_it_snowWhether it will snow this hour (1 = yes, 0 = no)
chance_of_snowPercentage chance of snow this hour
vis_kmVisibility in km
vis_milesVisibility in miles
gust_mphWind gust speed in mph
gust_kphWind gust speed in kph
uvUV index

historical

Historical daily weather data for each configured location. Each record represents one day per location. Synced incrementally using date as the replication key, starting from start_date. Shares the same schema as the forecast stream.

Settings

API Key

WeatherAPI key (https://www.weatherapi.com/my/)

Locations

One or more locations to fetch weather data for. Accepts city names, US zip codes, UK/Canada postcodes, lat/lon pairs, airport codes, IP addresses, and Search API IDs. See https://www.weatherapi.com/docs/#intro-request for full syntax. Use locations_file instead when syncing many locations.

Locations File

Path to a JSON file listing locations to sync. Format: [{"location": "90210", "custom_id": "beverly-hills"}, ...]. location accepts the same values as the locations setting. custom_id is optional; when provided it is passed through to each record and used to correlate bulk-request responses with the original query.

Start Date

Earliest date for historical data sync (YYYY-MM-DD).

End Date

Latest date for historical data sync, in ISO format. Defaults to yesterday's date.

Forecast Days

Number of days to include in the forecast stream (1-14).

Use Bulk Requests

Send all locations in a single POST request instead of one GET request per location. Requires a WeatherAPI Pro+, Business, or Enterprise plan. Each location in a bulk request still counts as one API call. See https://www.weatherapi.com/docs/#intro-bulk.

Bulk Request Chunk Size

Maximum number of locations per bulk POST request (5-50). When the location list exceeds this value the tap splits it into consecutive chunks of this size. Only applies when use_bulk_requests is true.

Meltano Cloud Connector

WeatherAPI connector is available on Meltano. It is built, maintained, supported, and tested by Meltano.

Why Meltano Cloud?
Expert supportDirect access to the team that built and maintains Meltano Cloud. Same-day responses during UK business hours. When something breaks, we fix it fast because we know exactly how it works.
Rigorously testedEvery connector goes through comprehensive testing and quality checks before production. Daily monitoring catches issues before they hit your pipelines. We don't just wrap open-source taps and hope for the best. We validate, we test, we maintain.
No maintenance overheadAPI changes. Connector updates. Schema drift. Breaking changes from upstream sources. We handle it all. Your team focuses on using data. Our team focuses on making sure it's there when you need it.
Ingest & transform data with AIConnect Claude or any MCP-compatible assistant to Meltano Cloud. Add connectors, run pipelines, build dbt models and diagnose failed runs in plain English, against the same Git-backed project your team works in.
Access to Meltano Slack communityJoin 5,500+ data engineers and analytics practitioners. The community is active, helpful, and always on. Good for quick questions, sharing patterns, and learning what others are building.