Search results
May 4, 2020 · 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, “Global Weather & Climate Data For BI,” which contains: Daily historical weather data from 2016 to the present.
- How Weather Data Can Improve Data Analytics - Blog
Whether they need detailed hourly and daily weather history...
- Snowflake for Data Warehouse | Snowflake Workloads
Snowflake for Data Warehouse. Accelerate data analytics with...
- What is Snowflake Datawarehouse?
July 27, 2021. Article Body. Written and originally...
- 10 Minute Beginner’s Guide to Snowflake Cloud Data Warehouse
The Snowflake Cloud Data Warehouse is the best way to...
- How Weather Data Can Improve Data Analytics - Blog
- 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
Learn the fundamentals of cloud data warehouse management using Snowflake. Snowflake is a cloud-based platform that offers significant benefits for companies wanting to extract as much insight from their data as quickly and efficiently as possible. Jan 2024 · 12 min read.
May 12, 2023 · Snowflake is built from scratch on the cloud and offers a variety of solutions based on the workload, type of data, type of sources, and consumers. Snowflake supports various workloads — Data...
