We want to move a stream of data with ~4k messages per hour to Snowflake, using Google Pub/Sub as temporary storage.
This is a real use case, consisting of all worldwide RSVPs on meetup.com being published in real time. This data has been collected from Meetup through their official API.
…
If you are a BigQuery user, you can find the Hacker News archive table on console.cloud.google.com/bigquery?p=bigquery-public-data&d=hacker_news&t=full&page=table.
This table contains an updated copy of Hacker News, as seen on my previous posts (when I used to work with the BigQuery team). …
Google Analytics 4 exports event data from individual user level for free into BigQuery. You might then be wondering “How do I move this data into Snowflake, to get all the benefits of the Data Cloud?” and “Is there a quick way to translate the sample BigQuery queries into Snowflake…
Brittany Bennett and Claire Carroll snipped data-twitter with a fun SQL puzzle. Hours later Benn Eifert had a great solution with SQL window functions. Then TJ Murphy tested it in Snowflake and explained why window functions are better than joins. And now, it’s my turn to play. Can I do…
The most popular languages on Reddit, after analyzing 1M comments: English, German(!), Spanish, Portuguese, French, Italian, Romanian(!), Dutch(!)…
Surprising results, compared to the # of native speakers:
German is the second most popular language on Reddit — Which probably is a big reason for Reddit opening an office in Berlin…
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. …
The Data Cloud not only allows you to share data, but also logic. Let’s check out the power of this by playing with GIS UDFs shared by CARTO.
Let’s start by plotting 1,000 random points around Italy:
Loading and analyzing reddit comments in Snowflake is fun, and a great way to show its powers. These are some of the Snowflake features that delighted me, that I didn’t get with BigQuery:
Let’s say you have a health and fitness app, and you’re wondering: What’s the best day to send notifications to your users? It’s Monday:
To access the daily NOAA GSOD weather data, just go to the Marketplace and create a database with Knoema’s Environment Data Atlas in your account.
With a couple of exploratory queries you’ll notice that:
