Auto alerts for Firebase users with Functions, Logging, and BigQuery

on YouTube ↗07m

" summary

Builds a Firebase restaurant-review app, routes Hosting request logs via a Cloud Logging sink into BigQuery, and queries aggregated HTTP status codes with a BigQuery remote function that calls a Cloud Function. The deployed function (tested locally with the Functions Framework, Node.js runtime) inspects each row and sends an email when a status code is >= 400 with count > 50. A scheduled query runs this regularly, and alerts are sent automatically.

AI-written summary · about

" chapters (5)

1. 0:00Introduction to serverless
2. 1:30Building the firebase app
3. 3:14Developing the alert function
4. 5:13Connecting BigQuery and alerts
5. 6:21Automation and conclusion

" related talks

• 46mFirebase & BigQuery - Do Mobile App Analytics Easily & at Scale - Queries IncludedFelipe Hoffa, Chad Jennings, Eugene Girard · Google Cloud Next '18
• 28mFirebase analytics for BigQueryArun Venkatesan, Todd Kerpelman · Google Cloud Next '17
• 54mFocus on Your Code, Not Infrastructure, with Google Cloud FunctionsMartin Omander · Windcity DevFest 2019
• 48mWhat’s new in FirebaseDoug Stevenson · Chicago Roboto 2017
• 29mCrash-reporting taken to next-levelTahsin Dane, Savan Ajamoglu · droidcon Berlin 2022
• 33mRealtime Awesomeness: An Intro to Building Apps With FirebaseSara Robinson · Codemotion Rome 2015
• 37mBuilding Scalable Apps with Cloud FirestoreDan McGrath · Google Cloud Next '18
• 36mCodelab: Build an Android app with Firebase and Cloud FirestoreAbe Haskins · droidcon San Francisco 2017