Try to remove the DROP TABLE IF EXISTS statement.

CREATE OR REPLACE EXTERNAL TABLE handles both creating and replacing the table reliably, so the DROP is unnecessary and causes the problem.

If the issue persists, I suggest opening a support ticket for a detailed analysis.