OHDSI / OHDSI/FeatureExtraction
createConnectionDetails() with snowflake dbms
Nobody has claimed this yet.
- Dominant language
- R
- Stars
- 74
- Forks
- 63
- PR merge metrics
- No merged PRs in 30d
Description
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!
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by tracing createConnectionDetails() into connectUsingJdbcDriver() and how getDbCovariateData() consumes the resulting connection details. Reproduce the Snowflake JWT configuration and determine what must change so the connection succeeds without a password; done means the reported connection-property error is resolved for this configuration.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- r
- Domain
- database
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100