Unable to delete a partition on Athena Table

I could see that you are trying to drop a partition in your query. As a general guidance, error in such scenarios come mostly due to the following reason.

1-> Please check if you are running this query in a table or view. i.e if "s4_gateway_transaction_base_tab_new" is a view or table.

2-> If "s4_gateway_transaction_base_tab_new" is a view, then partitions cant be deleted from view, since Athena doesn’t treat views as partitioned, a view is a logical table not a physical one.

3-> If "s4_gateway_transaction_base_tab_new" is a table, then you can check if the partition you are trying to drop exits or not, for this you can do a show partition query on the table, or you can even look that at the left side of the pane, it should be visible under table name.

4-> It could be an intermittent issue, please try to re run the query once.