I just found an interesting article that shows how to do CTAS on more than 100 partitions in Athena: https://docs.aws.amazon.com/athena/latest/ug/ctas-insert-into.html This means, that Airflow combined with this article, can resolve the limitation 100 paritions of using Athena.