darwin-eu / darwin-eu/CDMConnector
cdmFromCon fails on Snowflake with glue ≥ 1.8: glue_sql: .con is absent but must be supplied
- Dominant language
- HTML
- Stars
- 17
- Forks
- 17
- PR merge metrics
- No merged PRs in 30d
Description
`CDMConnector::cdmFromCon()` failed when connecting to Snowflake and the write/CDM schema resolves a two-part (catalog + schema) name. The connection worked after installing glue 1.7.0
```
Error in glue::glue_sql("{DBI::dbQuoteIdentifier(con, s[1])}.{DBI::dbQuoteIdentifier(con, s[2])}") :
`.con` is absent but must be supplied.
```
Here is the `traceback()` output:
```
stop("`.con` is absent but must be supplied.")
6: glue::glue_sql("{DBI::dbQuoteIdentifier(con, s[1])}.{DBI::dbQuoteIdentifier(con, s[2])}") at cdm.R#298
5: CDMConnector::cdmFromCon(con = db, cdmSchema = cdmSchema, writeSchema = writeSchema,
writePrefix = writePrefix, achillesSchema = achillesSchema) at RunDiagnostics.R#14
```
Thanks!
Contributor guide
Assessment
This issue has not been assessed yet.