Resolving Unknown Package Inserts into BigQuery from Firebase Apps
Daniel Marino
15 December 2024
Resolving Unknown Package Inserts into BigQuery from Firebase Apps

This article explores the problem of unknown software packages inserting data into BigQuery without authorization, emphasizing the function of Firebase and its security features. It describes how vulnerabilities are exploited by reverse-engineered APKs and how to stop these invasions by using Firebase rules, SHA certificates, and real-time monitoring.

How to Use SQL in Google BigQuery to Format Names in the Correct Case
Mia Chevalier
20 November 2024
How to Use SQL in Google BigQuery to Format Names in the Correct Case

When names like "STEVE MARK" and "Jonathan Lu" coexist, it can be difficult to deal with uneven name formatting in Google BigQuery. You may effectively standardize names to proper case using methods like INITCAP, REGEXP_REPLACE, and UDFs, guaranteeing that your data is clear, polished, and prepared for analysis.