public auth code: 7c_XY8PK9LS93F9_uWot

public auth code: Pa83VtnnYH0gamH6TPFW

What's the best way of filtering the data?

LiveviewRaw can do some filtering by the key (which is timestamp) https://firebase.google.com/docs/database/web/lists-of-data#filtering_data so realistically we can only really choose the date range, and perform multiple queries to select the sensors of interest at the database level. Once data is in notebook we can do more filtering clientside (JS or duckdb,) Bandwidth is an issue for wide date ranges, if you need like a monthly view, we need daily rollups so the raw sensor data is not transmitted.

Is it possible to use the SQL cell with this firebase connection?

You would need to load the data into duckdb first but yeah, that could be a nice enhancement https://observablehq.com/@cmudig/duckdb-client