delete_partitions_and_data: Deletes partitions and the underlying data on S3 from an...

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

Deletes partitions and the underlying data on S3 from an Athena database table matching an expression.

Description

Deletes partitions and the underlying data on S3 from an Athena database table matching an expression.

Usage

delete_partitions_and_data(database, table, expression)

Arguments

database	The database name.
table	The table name.
expression	The expression to match.

See Also

https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/glue.html#Glue.Client.get_partitions

Examples

`dbtools::delete_partitions_and_data("my_database", "my_table", "year = 2020 and month = 5")`

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