darwin-eu / darwin-eu/CDMConnector

cdmFromCon fails on Snowflake with glue ≥ 1.8: glue_sql: .con is absent but must be supplied

Open
#54 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.