Colin Rogers

Thanks for clarifying @maksym-dibrov-solidgate! Discussed this with the team, this behavior is due to dbt not supporting parallel runs. Specifically we're limited by: 1. Each run having it's own cache...

I think we should treat this as a new feature and fully support altering tables dist/sort keys in addition to columns similar to what we do now for materialized views.

Re-opening as offline conversation with the Redshift team indicates we _may_ be able to support this use case

We also want to incorporate sanity testing cases into completing this issue

It seems like we want to change the default eventually to not perform the order by. We would want to do this with a combination of Behavior Flags and a...

So while we still need to investigate and plan if/how we can support secondary roles in #803 we will definitely need to investigate why `on-run-start` isn't behaving as expected. Realistically...

We have also gotten some user reports of running into this: ``` {'S': 'FATAL', 'C': '28000', 'M': 'password authentication failed for user "usr.dbt"', 'F': '/opt/brazil-pkg-cache/packages/RedshiftPADB/RedshiftPADB-1.0.9768.0/AL2_aarch64/generic-flavor/src/src/pg/src/backend/libpq/auth.c', 'L': '425', 'R': 'auth_failed'} ```

@brifitz Thanks for the PR, we recently migrated this package to [dbt-labs/dbt-adapters](https://github.com/dbt-labs/dbt-adapters/tree/main/dbt-snowflake), can you move your PR there?

@MichelleArk curious if this issue might be a code smell for us to eventually move some of this functionality into the base adapter? That would enable different adapters to handle...

@AkhilGurrapu thanks for the proposal! You'll need to sign the CLA and migrate this PR to [dbt-adapters](https://github.com/dbt-labs/dbt-adapters/tree/main/dbt-snowflake) as we have moved dbt-snowflake development there Beyond that some high level feedback:...