You can also get this error if the role isn't granted USAGE on the file format.

If that's the case

GRANT USAGE ON FILE FORMAT MY_CSV_UNLOAD_FORMAT TO ROLE MY_ROLE_NAME