The message "Normalization and Transformation operations are not supported for this connection" is displayed because Airbyte has deprecated the normalization and custom dbt features. This means that these features are no longer supported and will be removed from the project soon. This is likely the reason why you're seeing this message when trying to use transformations with Redshift as the destination. For post-transformations of your data, Airbyte recommends using dbt with an orchestrator to run the job to your pipeline. You can find more information about this in the [discussion on Github](
https://github.com/airbytehq/airbyte/discussions/38168).