dwh_connect: Connect to DWH

In auth0/rauth0: Tools for data manipulation in Auth0

Description

Use credentials provided in ini file to connect to DWH, and return the connection pointer

Usage

dwh_connect(credentials_file = "~/.dwh_credentials", sslmode = "require",
  bigint = "numeric")

Arguments

credentials_file	The file where the host, database, user, password and port are
sslmode	Type of SSL requirement to send to PGSQL's client, Auth0's DWH will only accept SSL connections
bigint	The R type that 64-bit integer types should be mapped to, default is numeric (float), which modifies very big numbers, in some scenarios we may need to switch to integer64 to capture it accurately. The possible options are numeric, integer, character and integer64

Examples

con = dwh_connect()
tenants = tbl(con, 'tenants')

auth0/rauth0 documentation built on July 3, 2021, 4:11 p.m.