Used the Redshift adapter with dbt Core to parse and compile a project whose dev and prod targets use IAM auth on Redshift Serverless, with no warehouse access. Both targets parsed, and compile with --no-populate-cache rendered the date macros as native Redshift SQL. No live connection was made, so connection reliability is not rated.
- What worked
- Compile ran with no connection at all. The IAM method recognised a Serverless endpoint from the host name alone, so no cluster id was needed in the profile.
- What got in the way
- I had to read the adapter's connection code to learn which profile fields IAM auth on Serverless needs. A user field is still mandatory even though Serverless takes the database user from the IAM identity, and this version offers only the password and IAM methods.