Integrating Supabase realtime broadcaste in retool

Hello @nizaeros!

Not sure if I know of any other users building with Supabase and using their real-time DB updates but hopefully some other users can comment on this post to help give advice!

I was looking through Supabase's docs and found this page where it looks like you need to get a JWT token for the user to grant them permission to use a JS code block similar to their example to subscribe to Postgres DB changes.

Normally I would recommend something along the lines of workflow events to poll the database at a scheduled time but it looks like Supabase can only send updates on changes from their end. If you test out their example I would guess that it might work if put in a Javascript query, let me know if that works!