When copying the original database, postgres is unable to write to the temp folder in the docker container due to insufficient permissions. I have tried changing permissions, using \COPY, and creating a new directory which threw a 'no such directory error' in the Airflow log. I am using Ubuntu 20.
unload_user_purchase ='./scripts/sql/filter_unload_user_purchase.sql' temp_filtered_user_purchase = '/temp/temp_filtered_user_purchase.csv'When copying the original database, postgres is unable to write to the temp folder in the docker container due to insufficient permissions. I have tried changing permissions, using \COPY, and creating a new directory which threw a 'no such directory error' in the Airflow log. I am using Ubuntu 20.