- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to use Boto3 to delete a table from AWS Glue Data catalog?
Problem Statement − Use boto3 library in Python to delete a table, created in your account.
Example − Delete a table ‘security’ from database ‘test’ that is created in your account.
Approach/Algorithm to solve this problem
Step 1 − Import boto3 and botocore exceptions to handle exceptions.
Step 2 − Pass the parameter database_name and table_name that should be deleted from AWS Glue Catalog.
Step 3 − Create an AWS session using boto3 library. Make sure region_name is mentioned in default profile. If it is not mentioned, then explicitly pass the region_name while creating the session.
Step 4 − Create an AWS client for glue.
Step 5 − Now use delete_table function and pass the database_name as DatabaseName parameter and table_name as Name parameter.
Step 6 − It will delete the table and return the response metadata.
Step 7 − Handle the generic exception if something went wrong while checking the job.
Example
Use the following code to delete a table from AWS Glue database −
import boto3 from botocore.exceptions import ClientError def delete_a_table_from_database(database_name, table_name): session = boto3.session.Session() glue_client = session.client('glue') try: response = glue_client.delelte_table(DatabaseName= database_name, Name = table_name) return response except ClientError as e: raise Exception( "boto3 client error in delete_a_table_from_database: " + e.__str__()) except Exception as e: raise Exception("Unexpected error in delete_a_table_from_database: " + e.__str__()) print(delete_a_table_from_database("test","security"))
Output
{'ResponseMetadata': {'RequestId': '7aa7c3cb…………….-8610318a238c', 'HTTPStatusCode': 200, 'HTTPHeaders': {'date': 'Sun, 21 Feb 2021 04:58:04 GMT', 'content-type': 'application/x-amz-json-1.1', 'contentlength': '2', 'connection': 'keep-alive', 'x-amzn-requestid': '7aa7c3cbf611-494e-b923-8610318a238c'}, 'RetryAttempts': 0}}