Help Center> Data Warehouse Service> Best Practices> Tutorial: Tuning Table Design> Step 9: Cleaning Up Resources
View PDF

Step 9: Cleaning Up Resources

After completing this tutorial, delete the cluster by following the instructions provided in Service Overview.

If you want to keep the cluster, but delete the storage space used by the SS tables, run the following commands:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
 
DROP TABLE store_sales;
DROP TABLE date_dim;
DROP TABLE store;
DROP TABLE item;
DROP TABLE time_dim;
DROP TABLE promotion;
DROP TABLE customer_demographics;
DROP TABLE customer_address;
DROP TABLE household_demographics;
DROP TABLE customer;
DROP TABLE income_band;