Search results
May 4, 2020 · Justin Langseth, Data Exchange CTO at Snowflake, interviewed Gibbas and discussed how different types of weather datasets are helping companies with their data analytics. Weather Source provides hyper-local weather and climate data, distinguishing it from other weather data providers.
- Italiano
Whether they need detailed hourly and daily weather history...
- Snowflake Marketplace
Daily and hourly past, forecast & climatology weather data...
- Data Collaboration for the Climate
GET DIRECT ACCESS TO ENVIRONMENTAL DATA WITHIN SNOWFLAKE....
- Italiano
Oct 5, 2021 · Oct 5, 2021. You can use Snowflake to find correlations between your past data and historical weather data, and also to find a source of weather predictions into the future.
- Felipe Hoffa
- 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
On the Snowflake Marketplace, we offer our broad portfolio of available weather data: On the one hand historical weather data and on the other hand of course weather forecasts – each with a wide range of weather parameters from temperature, cloud cover, precipitation to dew point, precipitation probability or wind speed.
This entry-level guide designed for database and data warehouse administrators and architects will help you navigate the Snowflake interface and introduce you to some of our core capabilities. Sign up for a free 30-day trial of Snowflake and follow along with this lab exercise.
