There is the parameter "Single=True" that would remove the UUID part from the file that is being unloaded to S3 using the "copy into" command. https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

but for the custom filename, I think you will need a Stored Proc to achieve that during the file unload operation.