Skip to main content

Weatherstack

Tables in the Weatherstack connector

NoTable NameColumnsPrimary KeysRead ModeInc. Sync KeysAPI Info
1historical4Full Refresh
2forecast4Full Refresh
3location_lookup2Full Refresh
4current_weather3Full Refresh

Table: historical

NoColumn NameTypeNotes
1requestVARCHAR
2currentVARCHAR
3historicalVARCHAR
4locationVARCHAR

Table: forecast

NoColumn NameTypeNotes
1requestVARCHAR
2currentVARCHAR
3locationVARCHAR
4forecastVARCHAR

Table: location_lookup

NoColumn NameTypeNotes
1requestVARCHAR
2resultsVARCHAR

Table: current_weather

NoColumn NameTypeNotes
1requestVARCHAR
2currentVARCHAR
3locationVARCHAR

External Resources

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.