Skip to content

Instantly share code, notes, and snippets.

@krlmlr

krlmlr/columns.R

Last active June 15, 2022 02:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save krlmlr/1ced9ac9d115c6b0092be03863330838 to your computer and use it in GitHub Desktop.
Save krlmlr/1ced9ac9d115c6b0092be03863330838 to your computer and use it in GitHub Desktop.
Download ZIP
Script to query information_schema.columns with dm >= 0.2.8.9007
Raw
columns.R
library(dm)
# Connect to your database here
con <- DBI::dbConnect(duckdb::duckdb())
meta <- dm:::dm_meta(con, simple = TRUE)
# Does this work?
meta %>%
dm_ptype()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment