Can't get DBT to connect to redshift

[cyberaa]

Hey folks,

I have a serverless Redshift workgroup called "analytics-redshift" in a namespace called "analytics".

This is my AWS profile

[profile myprofile]
region = us-east-1
role_arn = arn:aws:iam::xxxx:role/dbt-redshift-access
source_profile = myprofile

The role has full admin and full redshift permissions.

and this is my Redshift /home/ubuntu/.dbt/profiles.yml

redshift:
  outputs:
    dev:
      dbname: dev
      host: analytics-redshift.xxxxxx.us-east-1.redshift-serverless.amazonaws.com
      cluster_id: analytics-redshift
      method: iam
      port: 5439
      schema: public
      threads: 1
      type: redshift
      user: admin
      region: us-east-1
  target: dev

However, when I try dbt debug I always get the following error:

14:31:24  Running with dbt=1.7.11
14:31:24  dbt version: 1.7.11
14:31:24  python version: 3.10.12
14:31:24  python path: /home/ubuntu/.venv/bin/python
14:31:24  os info: Linux-6.5.0-1014-aws-aarch64-with-glibc2.35
14:31:25  Using profiles dir at /home/ubuntu/.dbt
14:31:25  Using profiles.yml file at /home/ubuntu/.dbt/profiles.yml
14:31:25  Using dbt_project.yml file at /home/ubuntu/dbt_project.yml
14:31:25  adapter type: redshift
14:31:25  adapter version: 1.7.4
14:31:25  Configuration:
14:31:25    profiles.yml file [OK found and valid]
14:31:25    dbt_project.yml file [OK found and valid]
14:31:25  Required dependencies:
14:31:25   - git [OK found]
14:31:54  Registered adapter: redshift=1.7.4
14:31:55    Connection test: [ERROR]
...
14:31:55  1 check failed:
14:31:55  dbt was unable to connect to the specified database.
The database returned the following error:

  >Database Error
  An error occurred (ResourceNotFoundException) when calling the GetCredentials operation: Serverless workgroup analytics-redshift not found.

Check your database credentials and try again. For more information, visit:
https://docs.getdbt.com/docs/configure-your-profile

Network wise, it's accessible:

(.venv) ubuntu@ip-172-31-1-56:~$ nc -vz analytics-redshift.xxxx.us-east-1.redshift-serverless.amazonaws.com 5439
Connection to analytics-redshift.xxxx.us-east-1.redshift-serverless.amazonaws.com (xxx.xxx.xxx.xxx) 5439 port [tcp/*] succeeded!

Does anyone know what's wrong? The message is not very clear as the region is correct and the serverless instance does exist.

Thanks!