Cannot load JDBC driver class 'net.snowflake.client.jdbc.SnowflakeDriver'

Ignition 8.3 Early Access
14

Ok so i just tested this locally:

  1. download the JDBC snowflake Jar
  2. install the jar as a connector in the web UI. I did not hit a size issue here, but I admit in my dev environment i might have increased the upload size.
  3. I have successfully created a Database Connection to my test instance of snowflake. Note that i had to alter the default JDBC_QUERY_RESULT_FORMAT to JSON instead of Arrow. It looks like their JDBC driver expects the arrow dependency and its not included in their JDBC driver jar

I basically followed This KB article with the additional bits of setting JDBC_QUERY_RESULT_FORMAT as mentioned here and I end up with valid connections to my snowflake instance

image
image2290×454 36.1 KB

This definitely points to this being a permissions issue or something. After you altered the permissions of the jar file did you trigger a resource rescan? It can be done from the Platform web ui page in the top right corner:

image

database-connection

config.json on disk:

{
  "connectURL": "jdbc:snowflake://<MY_INSTANCE>.snowflakecomputing.com",
  "connectionProps": "",
  "connectionResetParams": "",
  "defaultTransactionLevel": "DEFAULT",
  "driver": "Snowflake",
  "evictionRate": -1,
  "evictionTests": 3,
  "evictionTime": 1800000,
  "failoverMode": "STANDARD",
  "failoverProfile": "",
  "includeSchemaInTableName": false,
  "password": {
    "data": {
      "ciphertext": "XXX",
      "encrypted_key": "XXX",
      "iv": "XXX",
      "protected": "XXX",
      "tag": "XXXX"
    },
    "type": "Embedded"
  },
  "poolInitSize": 3,
  "poolMaxActive": 8,
  "poolMaxIdle": 8,
  "poolMaxWait": 5000,
  "poolMinIdle": 0,
  "slowQueryLogThreshold": 60000,
  "testOnBorrow": true,
  "testOnReturn": false,
  "testWhileIdle": false,
  "translator": "GENERIC",
  "username": "<MY_USER>",
  "validationQuery": "SELECT 1",
  "validationSleepTime": 10000
}

database-driver

config.json:

{
  "classname": "net.snowflake.client.jdbc.SnowflakeDriver",
  "defaultPropInstructions": "",
  "defaultProps": "",
  "defaultTranslator": "GENERIC",
  "defaultValidationQuery": "SELECT 1",
  "type": "GENERIC",
  "urlFormat": "jdbc:snowflake://\u003caccount_identifier\u003e.snowflakecomputing.com",
  "urlInstructions": ""
}

resource.json:

{
  "scope": "A",
  "description": "",
  "version": 1,
  "restricted": false,
  "overridable": true,
  "files": [
    "config.json",
    "snowflake-jdbc-3.26.0.jar"
  ],
  "attributes": {
    "lastModification": {
      "actor": "<IGNITION_USER>",
      "timestamp": "2025-08-22T14:13:01Z"
    },
    "uuid": "6f7f1abc-f9ee-47e9-9ba7-29e5ce828608",
    "lastModificationSignature": "c00060d211ed9a6f4ea287003e26933ec8744ff56922ea0de3da18460ace9a99",
    "enabled": true
  }
}

driver directory overview:

image
image806×338 23.2 KB