MWAA 2.10.3 Support

[amw349]

I'm trying to migrate off astronomer-cosmos to this package, but I keep getting dependency conflicts with the MWAA constraints for Airflow 2.10.3. I'm using the Redshift as my warehouse. Is there a way to run this in a virtualenv similar to cosmos or MWAA + dbt guide and only install my redshift-adapter in the startup script on worker nodes? Would love to use this instead of plain dbt commands using BashOperator, but the dependency issues don't allow.

I can get my DAGs to run locally, but as soon as the constraints file is imposed in my MWAA env, I get the dependency issues.