I am aware there is an accepted answer that helped me, but the connection was not established with the message 'need further details.' However, I need to do some extra configuration to establish the connection. I followed accepted answer for jdbc driver(downloaded snowflake-jdbc-3.15.1.jar ) and to configure db_connection_types.conf ( don't copy and paste it from accpeted answer. see below db_connection_types.conf Followed below link to fix the issue: could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.util.MemoryUtil https://community.snowflake.com/s/article/JDBC-OutOfDirectMemoryError I added the first two options from the above solution (you can see below in case the above link is broken or removed) to the JVM Options in connection settings with a space delimiter. It didn't work. However, the connection got established with the third solution. (See db_connections.conf also to understand how that parameter is used.) 1.) Increase the maximum heap size, which in return will increase the maximum direct memory size. You will need to refer to the application's documentation for instructions on how to configure this value because it is application-specific. If you were starting the application using the java command then any of the following JVM arguments will set the maximum heap size to 1 GB:
-Xmx1048576k
-Xmx1024m
-Xmx1g
2.) Explicitly increase the maximum direct memory size. E.g., the following JVM sets the value to 1 GB:
-XX:MaxDirectMemorySize=1g
3.) If for any reason you do not have any control over the amount of memory you can allocate to your JVM (e.g., you are limited by the size of the container you're running in and it cannot be configured) then change the query result set from ARROW to JSON.
You can pass this setting as a connection parameter using your JDBC driver:
JDBC_QUERY_RESULT_FORMAT=JSON Final db_connections.conf and db_connection_types.conf local/db_connection_types.conf
[snowflake]
displayName = Snowflake
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcDriverClass = net.snowflake.client.jdbc.SnowflakeDriver
jdbcUrlFormat = jdbc//:/?db=
ui_default_catalog = $database$
port = 443
local/db_connections.conf
[Snowflake_DB]
connection_properties = {"JDBC_QUERY_RESULT_FORMAT":"JSON"}
connection_type = snowflake
customizedJdbcUrl = jdbc//.snowflakecomputing.com:443/?user=&db=snowflake&warehouse=&schema=public
database = snowflake
disabled = 0
host = .snowflakecomputing.com
identity = SnowflakeUser
jdbcUseSSL = false
localTimezoneConversionEnabled = false
port = 443
readonly = false
timezone = Etc/UTC
... View more