This is my first question in the community forums so I hope this isn’t too long or in the wrong category.
I am writing a program that establishes a database connection (via ODBC), retrieves table and view information for schemas within the database then grabs unique table and view names. I am able to successfully display column information and other meta-data for each table and view I retrieved from the schema using plyr.
I have been unsuccessful in changing my plyr line of code to purr. How could this be done using Purrr (i.e. the last line below)?
library("RODBC", warn.conflicts = FALSE) library("dplyr", warn.conflicts = FALSE) library("stringr", warn.conflicts = FALSE) library("fst", warn.conflicts = FALSE) con <- RODBC::odbcConnect(dsn = db, believeNRows = TRUE) db_objects <- RODBC::sqlTables(con, tableType = c("TABLE", "VIEW")) table_names <- db_objects$TABLE_NAME %>% base::unique() tables_all_cols <- plyr::ldply(table_names, function(x) RODBC::sqlColumns(con, x))