Is it possible to assign specific roles for compute nodes? For example I want one compute node to be reserved for real time queries for the users
Not at this time for community open source version. The cloud managed version from Celerdata does provide this feature. It’s called multi-warehouse.