Search results
May 4, 2020 · Whether they need detailed hourly and daily weather history or detailed forecasts for anywhere in the world, Weather Source has the data. Snowflake customers can access these rich datasets in Snowflake Data Marketplace directly from their Snowflake accounts. To provide an example, Weather Source offers Snowflake customers a free data listing ...
- Find Cities
- Geolocate Stations
- Pattern matching: Rainiest Cities
- Everything Together in DBT
- Next Steps
- Want More?
Now, how do we find the city closest to each station? Or the zip code? Let’s start by finding a list of worldwide cities. In this case I used data from Wikidata (we can talk more about Wikidata on Snowflake in a future post).
With a list of cities and Snowflake’s GIS support we can find the city closest to each station: In that SQL query we limited the search of st_distancewith a radius of 50km. This geo-join performed pleasantly fast: 3 seconds with a small warehouse. Note that the qualify row_number() over(partition by station order by distance) = 1 brings us the city...
Now let’s have some fun with pattern matching, thanks to our new MATCH_RECOGNIZE powers. For example let’s find the cities in the US that had the most number of consecutive days with rain: I love how easy is to define a pattern between rows with MATCH_RECOGNIZE: 1. First we define rain (for the pattern) as any row that has rain > 0.1inches. If the ...
Check out my GitHub project with a full dbt project. (Thanks to Noel Gomez and Mike Weinberg for their review on the dbt Slack)
Explore premium weather providers in the Snowflake Data Marketplace.Try this out with a Snowflake free trialaccount — you only need an email address to get started.Find plenty more datasets in the Snowflake Data Marketplace.I’m Felipe Hoffa, Data Cloud Advocate for Snowflake. Thanks for joining me on this adventure. You can follow me on Twitter and LinkedIn, and check reddit.com/r/snowflakefor the most interesting Snowflake news.
- Felipe Hoffa
Oct 5, 2021 · Watch on Youtube. With a premium global weather data provider like Weather Source, you can find richer and more localized data and with a deep historical database going back 20 years and into the ...
- Felipe Hoffa
Weather data from METEONOMIQS in the Snowflake Marketplace. 17.10.2022. Many companies rely on the Snowflake Data Cloud as a unified data platform to share, connect and analyze their data across business units. Many of these companies need weather data in their analytical pipelines to answer essential questions.
Oct 9, 2019 · The key component to building this model was weather forecast data. We looked at API’s from various online weather data providers, like weather.gov and a few others. We went with Dark Sky because it had a number of features in which we were interested. Current conditions by Latitude/longitude
The sample weather data has been deprecated and may not be available in some regions. OpenWeatherMap is a repository of recent historical and forecasted weather data in JSON format. Snowflake imports this weather data and makes it available to all Snowflake accounts free of charge so you can experiment with our unique, high-performance semi ...
Be the first to know about new data products and providers added to the Snowflake Marketplace. Find, try, and buy live, ready-to-use data and applications you need to power innovative business solutions.
