awswrangler.catalog.delete_partitions

awswrangler.catalog.delete_partitions(table: str, database: str, partitions_values: List[List[str]], catalog_id: str | None = None, boto3_session: Session | None = None) → Any

Delete specified partitions in a AWS Glue Catalog table.

Note

This function has arguments which can be configured globally through wr.config or environment variables:

  • catalog_id

  • database

Check out the Global Configurations Tutorial for details.

Parameters:

  • table (str) – Table name.

  • database (str) – Table name.

  • catalog_id (str, optional) – The ID of the Data Catalog from which to retrieve Databases. If none is provided, the AWS account ID is used by default.

  • partitions_values (List[List[str]]) – List of lists of partitions values as strings. (e.g. [[‘2020’, ‘10’, ‘25’], [‘2020’, ‘11’, ‘16’], [‘2020’, ‘12’, ‘19’]]).

  • boto3_session (boto3.Session(), optional) – Boto3 Session. The default boto3 session will be used if boto3_session receive None.

Returns:

None.

Return type:

None

Examples

>>> import awswrangler as wr
>>> wr.catalog.delete_partitions(
...     table='my_table',
...     database='awswrangler_test',
...     partitions_values=[['2020', '10', '25'], ['2020', '11', '16'], ['2020', '12', '19']]
... )