collapse.tbl_sql

0th

Percentile

Force computation of query

collapse() creates a subquery; compute() stores the results in a remote table; collect() downloads the results into the current R session.

Usage
# S3 method for tbl_sql
collapse(x, ...)

# S3 method for tbl_sql compute(x, name = unique_table_name(), temporary = TRUE, unique_indexes = list(), indexes = list(), analyze = TRUE, ...)

# S3 method for tbl_sql collect(x, ..., n = Inf, warn_incomplete = TRUE)

Arguments
x

A tbl_sql

...

other parameters passed to methods.

name

Table name in remote database.

temporary

Should the table be temporary (TRUE, the default) or persistent (FALSE`)?

unique_indexes

a list of character vectors. Each element of the list will create a new unique index over the specified column(s). Duplicate rows will result in failure.

indexes

a list of character vectors. Each element of the list will create a new index.

analyze

if TRUE (the default), will automatically ANALYZE the new table so that the query optimiser has useful information.

n

Number of rows to fetch. Defaults to Inf, meaning all rows.

warn_incomplete

Warn if n is less than the number of result rows?

Aliases
  • collapse.tbl_sql
  • compute.tbl_sql
  • collect.tbl_sql
Documentation reproduced from package dbplyr, version 1.4.0, License: MIT + file LICENSE

Community examples

Looks like there are no examples yet.