dwh_replace_table_from_sql: Replace DWH Table from SQL

In auth0/rauth0: Tools for data manipulation in Auth0

Description

Replace data using an SQL query. The existing table will be dropped if it exists.

Usage

dwh_replace_table_from_sql(table_name, query, group_read = "DWH_READ",
  group_all = "DWH", slots = 1, pcon = NULL)

Arguments

table_name	The name of the table in Amazon Redshift
query	The query to execute to create the table in Amazon Redshift
group_read	The group that will have read access to the table
group_all	The group that will have all access to the table
slots	The number of slots to use
pcon	Optionally, use an existing connection, if not, will start a temporary connection to use

Examples

dwh_replace_table_from_sql('test_table', 'select 1')

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