dwh_statement: DWH Statement

In auth0/rauth0: Tools for data manipulation in Auth0

Description

Run statement in the Datawarehouse, without expecting a result, this is useful for DDL operations (create, update, insert, delete, etc)

Usage

dwh_statement(statement, pcon = NULL, slots = 1, bindValues = NULL)

Arguments

statement	The statement text to execute in Amazon Redshift
pcon	The connection to run the query on, if unspecified, a temporary connection will be created and closed while running the query
slots	The number of slots to run the statement on, by default 1
bindValues	List of values to bind to the statement

Examples

a=dwh_query('create temp table mytable as select 1', slots=2)
b=dwh_query('create temp table mytable as select ?, ?', slots=2, bindValues=c(1,2))

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