Redshift: Redshift driver/connection

Description

Redshift currently uses all the same method as Postgres, but allows provides an extension point for future methods and downstream packages.

Usage

Redshift()
# S4 method for RedshiftDriver
dbConnect(
  drv,
  dbname = NULL,
  host = NULL,
  port = NULL,
  password = NULL,
  user = NULL,
  service = NULL,
  ...,
  bigint = c("integer64", "integer", "numeric", "character"),
  check_interrupts = FALSE,
  timezone = "UTC"
)

Arguments

drv

Should be set to Postgres() to use the RPostgres package.

dbname

Database name. If NULL, defaults to the user name. Note that this argument can only contain the database name, it will not be parsed as a connection string (internally, expand_dbname is set to false in the call to PQconnectdbParams()).

host

Host and port. If NULL, will be retrieved from PGHOST and PGPORT env vars.

port

Host and port. If NULL, will be retrieved from PGHOST and PGPORT env vars.

password

User name and password. If NULL, will be retrieved from PGUSER and PGPASSWORD envvars, or from the appropriate line in ~/.pgpass. See http://www.postgresql.org/docs/9.6/static/libpq-pgpass.html for more details.

user

service

Name of service to connect as. If NULL, will be ignored. Otherwise, connection parameters will be loaded from the pg_service.conf file and used. See http://www.postgresql.org/docs/9.6/static/libpq-pgservice.html for details on this file and syntax.

...

Other name-value pairs that describe additional connection options as described at http://www.postgresql.org/docs/9.6/static/libpq-connect.html#LIBPQ-PARAMKEYWORDS

bigint

The R type that 64-bit integer types should be mapped to, default is bit64::integer64, which allows the full range of 64 bit integers.

check_interrupts

Should user interrupts be checked during the query execution (before first row of data is available)? Setting to TRUE allows interruption of queries running too long.

timezone

Sets the timezone for the connection. The default is "UTC". If NULL then no timezone is set, which defaults to the server's time zone.