create_temp_table: Create a temporary table

In moj-analytical-services/dbtools: Uses R wrapper function to send queries to athena.

Create a temporary table

Description

Create a temporary table

Usage

create_temp_table(sql, table_name)

Arguments

table_name	The name of the temp table you wish to create
sql:	The SQL table you want to create a temp table out of. Should be a table that starts with a WITH or SELECT clause.

Examples

`dbtools::create_temp_table("SELECT a_col, count(*) as n FROM a_database.table GROUP BY a_col", table_name="temp_table_1")`

moj-analytical-services/dbtools documentation built on Sept. 29, 2024, 2:06 a.m.