View a markdown version of this page

Step 4: (Optional) Cleanup - Amazon Keyspaces (for Apache Cassandra)
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).

Step 4: (Optional) Cleanup

Follow these steps to remove all the Amazon resources created in this tutorial. The Amazon Glue job stacks must be deleted before the parent infrastructure stack because they reference its exported values.

To remove the resources created in this tutorial

  1. Delete the Amazon S3 bucket contents created by bootstrap. Replace YOURACCOUNTID with your Amazon account ID.

    $ aws s3 rm s3://amazon-keyspaces-bulk-cli-aksglue-YOURACCOUNTID --recursive

  2. Delete the Amazon Glue job stacks created by the bootstrap command. These child stacks must be deleted before the parent stack. You can use the following commands.

    $ aws cloudformation delete-stack --stack-name aksglue-export
$ aws cloudformation delete-stack --stack-name aksglue-import
$ aws cloudformation delete-stack --stack-name aksglue-count

    Wait for the child stacks to finish deleting before proceeding. You can check the status with the following command.

    $ aws cloudformation wait stack-delete-complete --stack-name aksglue-export
$ aws cloudformation wait stack-delete-complete --stack-name aksglue-import
$ aws cloudformation wait stack-delete-complete --stack-name aksglue-count

  3. Delete the parent Amazon CloudFormation stack. This removes the Amazon S3 bucket resource and the IAM role created in this tutorial.

    $ aws cloudformation delete-stack --stack-name aksglue

  4. If you created a trigger in the previous step, delete it using the following command.

    $ aws glue delete-trigger --name KeyspacesExportWeeklyTrigger

  5. Delete the Amazon Keyspaces keyspace and table. Deleting the keyspace automatically deletes all tables in that keyspace. You can use one of the following options.

    Amazon CLI
    $ aws keyspaces delete-keyspace --keyspace-name 'catalog'

    To confirm that the keyspace was deleted, you can use the following command.

    $ aws keyspaces list-keyspaces

    To delete the table first, you can use the following command.

    $ aws keyspaces delete-table --keyspace-name 'catalog' --table-name 'book_awards'

    To confirm that your table was deleted, you can use the following command.

    $ aws keyspaces list-tables --keyspace-name 'catalog'

    For more information, see delete keyspace and delete table in the Amazon CLI Command Reference.

    cqlsh
    DROP KEYSPACE IF EXISTS "catalog";

    To verify that your keyspace was deleted, you can use the following statement.

    SELECT * FROM system_schema.keyspaces ;

    Your keyspace should not be listed in the output of this statement. Note that there can be a delay until the keyspace is deleted. For more information, see DROP KEYSPACE.

    To delete the table first, you can use the following command.

    DROP TABLE "catalog"."book_awards";

    To confirm that your table was deleted, you can use the following command.

    SELECT * FROM system_schema.tables WHERE keyspace_name = "catalog";

    Your table should not be listed in the output of this statement. Note that there can be a delay until the table is deleted. For more information, see DROP TABLE.