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.

...

Currently ignored.

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

Examples

# NOT RUN {
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)
df <- read_civis(id, using = read.csv)
# }