Amazon Redshift is a data warehouse product based on PostgreSQL. You can access the rtcstats databases HERE. We have a prod and a pilot database, use accordingly. Use username "admin" and "temporary credentials" to authenticate.
In this context a session equals an endpoint. The column name is statssessionid
. If you know the meeting unique id and you want to find all the endpoints/sessions in that call this SQL query will do:
SELECT statssessionid FROM "rtcstats"."public"."rtcstats"