Deleting an Amazon S3 table - Amazon Simple Storage Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Deleting an Amazon S3 table

You can delete a table by using the Amazon S3 REST API, Amazon SDK, Amazon CLI or using integrated query engines.

Note

S3 Tables doesn't support the DROP TABLE operation with purge=false. Some versions of Spark always set this flag to false even when running DROP TABLE PURGE commands. You can retry with DROP TABLE with purge=true or use the S3 Tables DeleteTable REST API to delete a table.

When you delete a table, the objects associated with that table become non-current and can take up to one day to get removed.

This example shows how to delete a table by using the Amazon CLI. To use the command replace the user input placeholders with your own information.

aws s3tables delete-table \
    --table-bucket-arn arn:aws-cn:s3tables:us-east-1:111122223333:bucket/amzn-s3-demo-table-bucket \
    --namespace example_namespace --name example_table

You can delete a table in an Apache Spark session connected to your Amazon S3 table buckets.

This example shows how to delete a table by using the DROP TABLE PURGE command. To use the command replace the user input placeholders with your own information.

spark.sql( 
" DROP TABLE [IF EXISTS] s3tablesbucket.example_namespace.example_table PURGE;