anthonysena
commented
8 hours ago Hi,
I haven't seen an example with using JWT to authenticate to Snowflake but it seems similar to what is done when we are connecting to Google BigQuery as shown here:
So you may want to skip using the extraSettings and construct a connectionString that includes the private key file paths and properties that you are using. I'd also suggest using absolute paths vs relative ones to make sure the resources can be found. You can test this out by constructing your connection details and then using DatabaseConnector to connect/disconnect to make sure the connection details are in working order. Then you can re-attempt to run FeatureExtraction.
Hi,
Trying to use createConnectionDetails() to them use as a parameter in getDbCovariateData(). However, I am trying to connect to snowflake where we use a JWT authenticator rather than individual passwords.
connectionDetails <- createConnectionDetails( dbms = "snowflake", server = keyring::key_get("server"), user = keyring::key_get("user"), connectionString = keyring::key_get("connectionString"), extraSettings = list(AUTHENTICATOR = "SNOWFLAKE_JWT", PRIV_KEY_FILE = fs::path_home(".p8/private_key.p8"), PRIV_KEY_FILE_PWD = Sys.getenv("PRIVATE_KEY_PWD")), pathToDriver = fs::path_home("...") )I've tried capturing my authenticator connection information under extraSettings but getting an error message:
Connecting using Snowflake driver Error in
connectUsingJdbcDriver(): ! Connection propery 'password' is NULL.Can someone advise? Thanks!