`dm` cannot discover schema from SQLite NASIS snapshot - no such table: information_schema.tables

[brownag]

learn_keys is a useful feature, but this issue is to make a note about generalizing the ability to discover schema when using SQLite snapshot, which may contain only a subset of the full NASIS data model

library(nasis)
# remotes::install_github("brownag/soilDBdata") # install (if needed)

dsn <- system.file("extdata", "fetchNASIS_pedons.sqlite", package = "soilDBdata")

d <- nasis(dsn)
#> Loading required namespace: soilDB
#> Loading required namespace: RSQLite
#> Loading required namespace: dbplyr
#> Keys could not be queried: ℹ In index: 1.
#> Caused by error:
#> ! no such table: information_schema.tables. Use `learn_keys = FALSE` to mute this message.