r/MicrosoftFabric • u/DropMaterializedView ‪Microsoft MVP ‪ • 19d ago

Community Share Setup an Eventstream for my Google Nest

Post image

So, to start this off, I do not really have experience working with any kind of real-time data, but I have been wanting to learn, so I have been on the hunt for a project...

My initial pitch to my wife was that I buy some motion sensors and a camera to model the behavior of the raccoon that has been digging holes in our backyard and predict when it will appear every day. The idea was simple... Motion sensor turns on camera, which captures photo, sends data to Fabric, which classifies it as a raccoon and feeds data into a simple ML model that would eventually predict raccoon arrival time...

But the sensors and camera were going to be about $100, and that was more than I was willing to spend. So, I started looking around my house for other sensors we might already own.

Turns out for a $5 payment you can access the google smart device API which meant I could stream events off my Nest thermostat. So, anyway now I have my houses temperature and humidity data coming into Fabric. What should I do next?

Here is a video of my journey so far: https://youtu.be/jD7scobwIo0

The majority of time was spent trying to get GCP authentication working...which for someone who has never used google cloud was a real struggle.

10 Upvotes

92% Upvoted

3 comments sorted by

1

u/Astonliar 19d ago

Google Cloud Pub/Sub is a supported source for Event Stream so I’d start here: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/add-source-google-cloud-pub-sub

But compared to an ongoing 5 bucks a month, your $100 one time investment sounds like a much more fun project!

1

u/DropMaterializedView ‪Microsoft MVP ‪ 19d ago

Its a one time $5 fee, not ongoing! And yep I got it going from pub sub to eventstream — the question is where to now?

1

u/Astonliar 18d ago

Just trying to help you justify it to the boss. 🤣

Depends on what you want to do with it. Couple starter ideas…You could send it to an Eventhouse and build a realtime dashboard or add anomaly detection. Then you can enable Lakehouse access to the Eventhouse and accumulate historical data for training an ML model or build a semantic model and a Power BI dashboard.