i want to extract a value from a json column. The schema is (- first level, — second level): Currently i extract a value this way: Is there a better way to handle the task? Answer Assuming that: event_params is an array of struct type. user_id is a unique key in each event_params Following code style would be possible: You
Tag: firebase
It is possible to use git as sql database [closed]
I know it’s not logical question,but if git is best solution for code save and work around with team and its use for many things. So why not its use like sql database. Or just store small amount of …
What is the equivalent of a collection and a document of firebase in sql?
My question is that what is the equivalent of a collection and a document of firebase in other databases like SQL or MongoDB, I know that there is a table in SQL but what is the equivalent of the …
How to get “session duration” group by “operating system” in Firebase Bigquery SQL?
I try to get the “average session duration” group by “operating system” (device.operating_system) and “date” (event_date). In the firebase blog, they give us this query to get the average duration session This query give me the total user engagement by user ID (each row is a different user): But I have no idea where I have to add the “operating
How to implement BETWEEN Sql query in Firebase?
I am working on a android Firebase project. I need help in implementing this sql query in Firebase real-time database. Answer There’s good documentation on how to do firebase queries as well as apply them to ranges. Something like: Then you add the appropriate listener for what you are trying to do. (e.g. a ValueEventListener or a ChildEventListener via addValueEventListener