`CTAS` that works in the Redshift query editor fails when run via a `PostgresHook` in MWAA due to mixed-case field
TL;DR A CTAS that works when run in the Redshift query editor fails when passed to Redshift via a PostgresHook in Airflow because of weirdness with a case-sensitive field in an external (RDS) table. The issue I’m building a small pipeline on Redshift using Airflow 2.7.2 on AWS MWAA. I’m using PythonOperator to manage a […]