dbRemoveTable: dbRemoveTable

In moj-analytical-services/Rdbtools: Connects the MoJ Analytical Platform to Athena

dbRemoveTable

Description

See noctua::dbRemoveTable(). This function calls noctua::dbRemoveTable(), after replacing any references to ⁠__temp__⁠ in the names argument with your temporary database in Athena.

Usage

## S4 method for signature 'MoJAthenaConnection,character'
dbRemoveTable(conn, name, delete_data = TRUE, confirm = FALSE, ...)

Arguments

conn	A DBIConnection object, as returned by connect_athena()
name	The table name, passed on to dbQuoteIdentifier(). Options are: a character string with the unquoted DBMS table name, e.g. "table_name", a call to Id() with components to the fully qualified table name, e.g. Id(schema = "my_schema", table = "table_name") a call to SQL() with the quoted and fully qualified table name given verbatim, e.g. SQL('"my_schema"."table_name"')
delete_data	Deletes S3 files linking to AWS Athena table
confirm	Allows for S3 files to be deleted without the prompt check. It is recommend to leave this set to FALSE to avoid deleting other S3 files when the table's definition points to the root of S3 bucket.
...	Other parameters passed on to methods.

moj-analytical-services/Rdbtools documentation built on June 22, 2024, 8:46 p.m.