IoT use case with Elastic compute, semi-structured data scalable – Frederik Oebius, Snowflake

Finding the answers, we need isn’t always as easy as it would seem. Before analysis can begin, we need to combine data from multiple disparate locations, transform oddly formatted or semi-structured files, find a secure place to store the data, and make it available for analysis. Today’s session will show how you can accomplish all of that -and more- using Snowflake.

The “story” of this lab is based on the analytics team at Citi Bike, a real, citywide bike share system in New York City, USA. This team wants to be able to run analytics on data to better understand their riders and how to serve them best.

We will load structured .csv data from rider transactions into Snowflake. This comes from Citi Bike internal transactional systems. Then later we will load open-source, semi-structured JSON weather data into Snowflake to see if there is any correlation between the number of bike rides and weather.

Add comment

Highlight option

Turn on the "highlight" option for any widget, to get an alternative styling like this. You can change the colors for highlighted widgets in the theme options. See more examples below.


Instagram has returned empty data. Please authorize your Instagram account in the plugin settings .

Ivana Kotorchevikj

Categories count color


Small ads


  • Traffic lights
  • WoMo
  • Setra presentation
  • It never ends
  • stand still screening-smoking girl
  • Maria d'Odessa performs her art of make-up
  • Afro-deko-mono
  • Maria d'Odessa, touching
  • Maria d'Odessa au bâton de rouge-baiser

Social Widget

Collaboratively harness market-driven processes whereas resource-leveling internal or "organic" sources.