New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Adopt DBI's approach for catalog & schema, deprecate databaseSchema. #283

Open

schuemie opened this issue Aug 15, 2024 · 1 comment

Assignees

Milestone

Member

schuemie commented Aug 15, 2024

These are two solutions to the same problem, but the DBI approach keeps the two separate, for example making it easier to add quotes.

From discussion #275

schuemie added this to the v7.0.0 milestone

Member Author

schuemie commented Aug 28, 2024

Not yet sure if that means DBI::Id() or R's native I() function.

E.g. this should work:

getTableNames(connection, DBI::Id(catalog = "cdm", schema = "dbo"))

Also make sure all DBI functions support DBI::Id(). From the DBI documentation, name should be character string, DBI::Id(), or SQL().

schuemie assigned ablack3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment