I intend to share a dashboard with a few peers, but don’t want them to have access to the Dashboard queries/Database/tables/schemas etc.

I am connected to Redshift, but don’t see any such permission. Also came across an old post here, but not sure if there’s any such provision in Redash. Currently I’m using Redash 8.0.

Let me know around the same if possible.

The only way to do this is with secret share links. The feature you linked has not been implemented but it’s high on our list.