I guess currently (Oct, 2024) this is not supported. I've bypassed that by defining function in Snowflake which do the COPY INTO maneuver and then calling it from native query in java.