Why does show users; show a list of users with their type as 'JWT'?
The users listed with 'JWT' are the ones who have access to the cluster using the Portal UI and SQL editor in the UI. They are also used for browser-based SSO to the engine.
The users are added with an internal 'JWT' User Sync job that is run when users are added or removed in the Portal UI. This Job takes all the users that belong to the organization and creates 2 'JWT' users.
One based on the user's email and another based on the UUID of the user.