sql_collect: Query and get data back into a data.frame

In vegdata: Access Vegetation Databases and Treat Taxonomy

Query and get data back into a data.frame

Description

Query and get data back into a data.frame

Usage

sql_collect(src, query, ...)

Arguments

src	(src) An 'src' object, result of calling [src_germansl()], [src_eurosl()]
query	(character) A SQL query
...	further args passed on to [dplyr::tbl()]

Details

we run [dplyr::tbl()], then [dplyr::collect()]

Examples

## Not run: 
src <- src_germansl()
sql_collect(src, "select * from GermanSL limit 5")
## or pipe the src to sql_collect
src %>% sql_collect("select * from GermanSL limit 5")

## End(Not run)

vegdata documentation built on May 29, 2024, 4:19 a.m.