I'm running into a similar issue here. I'm trying to get this set up locally and not in production so all the elementary tables are being generated in my personsal schema

dbt_alexandra

. I have this filled out in my

profiles.yml

elementary:
  outputs:
    default:
      type: redshift
      host: "localhost"
      port: 5439
      user: "{{ env_var('DB_USER') }}"
      pass: "{{ env_var('DB_PASSWORD') }}"
      dbname: db_name
      schema: dbt_alexandra
      threads: 1

and I'm getting

Could not find profile named 'elementary'

Is this happening because the schema name isn't

elementary

?