Export results from a query to S3 and return a file id.

Source: R/io.R

Exports results from a Redshift SQL query, and returns the id of the file on S3 for use with read_civis or download_civis.

query_civis_file(x, ...)

# S3 method for character
query_civis_file(
  x,
  database = NULL,
  job_name = NULL,
  hidden = TRUE,
  verbose = verbose,
  csv_settings = NULL,
  ...
)

# S3 method for sql
query_civis_file(
  x,
  database = NULL,
  job_name = NULL,
  hidden = TRUE,
  verbose = FALSE,
  csv_settings = NULL,
  ...
)

# S3 method for numeric
query_civis_file(x, database = NULL, verbose = FALSE, ...)

Arguments

x

"schema.table", sql("query"), or a sql script job id.
...

Options passed to scripts_post_sql, including credential.
database

string, Name of database where data frame is to be uploaded. If no database is specified, uses options(civis.default_db).
job_name

string, Name of the job (default: "Civis S3 Export Via R Client").
hidden

bool, Whether the job is hidden.
verbose

bool, Set to TRUE to print intermediate progress indicators.
csv_settings

See scripts_post_sql for details.

Details

By default, the export uses the default csv_settings in scripts_post_sql, which is a gzipped csv.

Methods (by class)

  • character: Export a "schema.table" to a file id.

  • sql: Export results of a query to a file id.

  • numeric: Run an existing sql script and return the file id of the results on S3.

See also

Other io: download_civis(), query_civis(), read_civis(), write_civis_file(), write_civis()

Examples

if (FALSE) {
id <- query_civis_file("schema.tablename", database = "my_database")
df <- read_civis(id, using = read.csv)

query <- sql("SELECT * FROM table JOIN other_table USING id WHERE var1 < 23")
id <- query_civis_file(query)
df <- read_civis(id, using = read.csv)

id <- query_civis_file(query_id, credential_id = 0000)
df <- read_civis(id, using = read.csv)
}