Retool apps are client-driven — the client needs to trigger queries, so it’s not possible to push updates from the server directly without the client requesting them.
As @bobthebear mentioned, the standard way to handle this is with polling. You can set your query to run every few seconds to keep the table data fresh.
If your query is expensive and you don’t want to refresh it constantly, one workaround is to create a lightweight “update events” table that tracks when changes happen. You can poll that table instead, and only re-run your main query when a new update is detected.
Some users have also reported success using WebSockets within Retool (via custom components or scripts), though that’s not something I’ve implemented personally.