Load Real-Time 911 Data to Snowflake

  • 12 March 2022
  • 0 replies
  • 40 views

Userlevel 1
  • StreamSets Employee
  • 0 replies

 

Read 911 Event Data and Load to Snowflake

This pipeline uses the HTTP client to read real time 911 event data from the Seattle Fire Department. 

  • The pipeline then flattens a nested JSON object
  • It also uses the latitude and longitude of the incident location to lookup the Census block information from the Census Bureau’s geocoding API.

Fun fact: While building this pipeline, an event came through for a dumpster fire currently happening on my block :fire::fire_engine: !


0 replies

Be the first to reply!

Reply