title: How to login to AWS Redshift as an IAM user
body: <p>I have an existing cluster, and an IAM user named 'dba-admin' with full permissions to manipulate it.</p>
  <p>I successfully generated temporary credentials generated from the CLI:</p>
  <pre><code>aws redshift get-cluster-credentials --cluster-identifier db --db-user dba-admin --duration-seconds 7200
  </code></pre>
  <p>However, when I go to the query v2 editor, and try and login:</p>
  <p><a href="https://i.stack.imgur.com/54Zvu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/54Zvu.png" alt="enter image description here" /></a></p>
  <p>I get the following error: <code>FATAL: user &quot;IAM:dba-admin&quot; does not exist; [SQL State=42704]</code> before I can enter the password.</p>
  <p><a href="https://i.stack.imgur.com/jRkps.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jRkps.png" alt="enter image description here" /></a></p>
  <p>I have not manually created a Redshift user named dba-admin, in my understanding this is unnecessary?</p>
  <p>Any ideas as to the issue?</p>