Snowflake: Snowflake DBI wrapper

In daroczig/AWR.Snowflake: Snowflake 'JDBC' 'DBI' Wrapper

Description

Snowflake DBI wrapper

Connect to Snowflake

Usage

Snowflake()

## S4 method for signature 'SnowflakeDriver'
dbConnect(drv, account_name,
  region_id = "us-west-2", user, password, db = "nodb",
  schema = "noschema", warehouse = "nowarehouse", ...)

Arguments

drv	An object created by Snowflake()
account_name	Snowflake account name, which is the subdomain part of your Snowflake warehouse
region_id	id of the region assigned to your Snowflake account
user	Snowflake username
password	Snowflake password
db	default database to use
schema	default schema to use
warehouse	default warehouse / compute cluster to use
...	other parameters passed to the JDBC driver

See Also

Snowflake JDBC Manual for more connections options.

Examples

## Not run: 
require(DBI)
con <- dbConnect(AWR.Snowflake::Snowflake(),
  account_name = 'foobar', user = 'username', password = '***', db = 'SNOWFLAKE_SAMPLE_DATA')
dbListTables(con)
dbGetQuery(con, 'SELECT COUNT(*) from TPCDS_SF100TCL.call_center')
dbGetQuery(con, 'SELECT * FROM tpch_sf1.lineitem limit 5')
dbDisconnect(con)

## End(Not run)

daroczig/AWR.Snowflake documentation built on May 28, 2019, 7:51 p.m.