Yes, Elementary OSS does support Redshift IAM authentication. According to the [Slack discussion](https://slack.com/archives/C02CTC89LAX/p1667937497212079), Elementary's CLI runs an internal dbt project and leverages it to connect to the data warehouse, so it works the same way as dbt does. This means you can use the IAM authentication setup that is documented in [dbt's Redshift setup guide](https://docs.getdbt.com/reference/warehouse-setups/redshift-setup#iam-authentication). The [connection establishment process](https://slack.com/archives/C02CTC89LAX/p1695962435849359) confirms that Elementary uses the

dbt-redshift

Python adapter along with the

profiles.yml

file for connection details, which supports IAM-based authentication. You can configure IAM authentication in your

profiles.yml

file following dbt's standard Redshift IAM authentication configuration, and Elementary will use those credentials to connect to your Redshift warehouse.