A 'dplyr' Back End for Databases


[Up] [Top]

Documentation for package ‘dbplyr’ version 2.1.1

Help Pages

anti_join.tbl_lazy Join SQL tables
arrange.tbl_lazy Arrange rows by column values
as.sql SQL escaping.
collapse.tbl_sql Compute results of a query
collect.tbl_sql Compute results of a query
complete.tbl_lazy Complete a SQL table with missing combinations of data
compute.tbl_sql Compute results of a query
copy_to.src_sql Copy a local data frame to a remote database
count.tbl_lazy Count observations by group
dbplyr_uncount "Uncount" a database table
distinct.tbl_lazy Subset distinct/unique rows
do.tbl_sql Perform arbitrary computation on remote backend
escape Escape/quote a string.
escape_ansi Escape/quote a string.
expand.tbl_lazy Expand SQL tables to include all possible combinations of values
fill.tbl_lazy Fill in missing values with previous or next value
filter.tbl_lazy Subset rows using column values
full_join.tbl_lazy Join SQL tables
group_by.tbl_lazy Group by one or more variables
head.tbl_lazy Subset the first rows
ident Flag a character vector as SQL identifiers
inner_join.tbl_lazy Join SQL tables
intersect.tbl_lazy SQL set operations
in_schema Refer to a table in a schema
is.ident Flag a character vector as SQL identifiers
is.sql SQL escaping.
join.tbl_sql Join SQL tables
left_join.tbl_lazy Join SQL tables
memdb_frame Create a database table in temporary in-memory database.
mutate.tbl_lazy Create, modify, and delete columns
pivot_longer.tbl_lazy Pivot data from wide to long
pivot_wider.tbl_lazy Pivot data from long to wide
pull.tbl_sql Extract a single column
relocate.tbl_lazy Subset, rename, and reorder columns using their names
remote_con Metadata about a remote table
remote_name Metadata about a remote table
remote_query Metadata about a remote table
remote_query_plan Metadata about a remote table
remote_src Metadata about a remote table
rename.tbl_lazy Subset, rename, and reorder columns using their names
rename_with.tbl_lazy Subset, rename, and reorder columns using their names
replace_na.tbl_lazy Replace NAs with specified values
right_join.tbl_lazy Join SQL tables
select.tbl_lazy Subset, rename, and reorder columns using their names
semi_join.tbl_lazy Join SQL tables
setdiff.tbl_lazy SQL set operations
simulate_access Backend: MS Access
simulate_hana Backend: SAP HANA
simulate_mysql Backend: MySQL/MariaDB
simulate_odbc Backend: ODBC
simulate_oracle Backend: Oracle
simulate_postgres Backend: PostgreSQL
simulate_redshift Backend: Redshift
simulate_snowflake Backend: Snowflake
simulate_sqlite Backend: SQLite
simulate_teradata Backend: Teradata
slice_max.tbl_lazy Subset rows using their positions
slice_min.tbl_lazy Subset rows using their positions
slice_sample.tbl_lazy Subset rows using their positions
sql SQL escaping.
sql_vector Escape/quote a string.
src_memdb Create a database table in temporary in-memory database.
summarise.tbl_lazy Summarise each group to one row
tally.tbl_lazy Count observations by group
tbl.src_dbi Use dplyr verbs with a remote database table
tbl_dbi Use dplyr verbs with a remote database table
tbl_memdb Create a database table in temporary in-memory database.
translate_sql Translate an expression to sql
translate_sql_ Translate an expression to sql
union.tbl_lazy SQL set operations
union_all.tbl_lazy SQL set operations
window_frame Override window order and frame
window_order Override window order and frame