Hi,
I am trying to configure jdbc(sql) to connect to snowflake, I need to add
some extra properties related to some sssk keypair like *prop.put("privateKey",
PrivateKeyReader.get(PRIVATE_KEY_FILE)); *
I tried below code in java, it works but how to add same in Zeppelin ? I
could not see any option to add extra option in jdbc interceptors . Is it
possible to add these extra props?
String url = "jdbc:snowflake://<account_identifier>.snowflakecomputing.com";
Properties prop = new Properties();
prop.put("user", "<user>");
prop.put("privateKey", PrivateKeyReader.get(PRIVATE_KEY_FILE));
prop.put("db", "<database_name>");
prop.put("schema", "<schema_name>");
prop.put("warehouse", "<warehouse_name>");
prop.put("role", "<role_name>");
Connection conn = DriverManager.getConnection(url, prop);
Statement stat = conn.createStatement();
ResultSet res = stat.executeQuery("select 1");
res.next();
System.out.println(res.getString(1));
conn.close();