flaky_connect: Create a connection to a Snowflake instance

In ndiquattro/flaky: Wrapper around an ODBC connection to SnowflakeDB and dbplyr backend

Description

Connect to Snowflake using a DSN or connection string.

Usage

flaky_connect(dsn = NULL, connection_string = NULL, set_default = TRUE, ...)

Arguments

dsn	Data Service Name as defined in '~/.odbc.ini'.
connection_string	Semi-colon separated string of key=value pairs. See Details for an example.
set_default	Set connection to default for session.
...	Additional ODBC keywords, these will be joined with the other arguments to form the final connection string.

Details

If using 'connection_string' it should be defined in the following structure: '"<name>=<value>;<name2>=<value2>"'.

Value

A connection object.

Author(s)

Nick DiQuattro

Examples

## Not run: 
# For a DSN named warehouse
con <- flaky_connect("warehouse")

# If you need to temporarily connect to a different set of credentials
other_con <- flaky_connect("warehouse_2", set_default = FALSE)

## End(Not run)

ndiquattro/flaky documentation built on Nov. 23, 2020, 6:26 p.m.