radothede
Valued Contributor II

Hi @shan-databricks ,

have You tried with DROPMALFORMED mode?

Regarding PERMISSIVE mode - could You share a code snippet?

If thats not resolving Your issue, I would recommend using custom try except logic.