Dataflow snowflake connection issue

I'm trying to set up a sink to snowflake in dataflow, but when I test the connection it doesn't work

It just comes out JDBC driver communication error, tried searching online and looking at documentation link but couldn't find anything about this issue.

But this same dataset works fine outside of the dataflow, I can preview the data in same dataset:

There seems to be issue with dataflow. Even when I try to execute the dataflow through pipeline the same error message comes up:

Does anyone know how to solve this problem with dataflows?

Also with the sink settings option if I select recreate table will it create the table in snowflake if it doesn't already exist?

Trying to find an easy way to copy a lot of tables into snowflake without explicitly having to create the table first especially if the metadata is only known at runtime, the pipeline copy job doesn't work as the table has to exist before it can insert data into it, but dataflow seems promising if the connection actually works.