← All posts
2 min read

Athena: Delete data catalog from the CLI

#aws#cli#athena#analytics#sql
📑 On this page

Part 799 of AWS from Zero. This is lesson 18 in the Athena track.

What we are learning

Use delete-data-catalog to remove, stop, release, or detach one Athena resource in a dependency-aware way. This lesson identifies the required input shape, saves the raw response, and keeps inspection separate from execution.

The AWS CLI operation is aws athena delete-data-catalog. Required operation inputs: --name (string). The modeled top-level response contains DataCatalog.

Before you run it

aws sts get-caller-identity
REGION="${AWS_REGION:-ap-south-1}"
NAME="replace-with-name"
aws athena delete-data-catalog help

Use a sandbox account or an approved learning environment. Read the operation help before supplying identifiers, ARNs, network ranges, policy documents, or customer data.

Cost note: Athena commonly charges for data scanned; storage and connected catalog services can also incur charges.

The command

aws athena delete-data-catalog \
  --name "$NAME" \
  --region "$REGION" \
  --output json > part-799-response.json

The response is saved to part-799-response.json so inspection is separate from execution. The explicit variables above keep required identifiers visible before the API call.

Inspect the result

node -e "const r=require('./part-799-response.json'); console.log(Object.keys(r))"
node -e "const r=require('./part-799-response.json'); console.log(JSON.stringify(r, null, 2))"

Compare the returned identifiers and status fields with the account, Region, and resource you intended to target. For asynchronous operations, continue with the service's matching get, list, or describe command until it reaches a terminal state.

One tiny variation

node -e "const r=require('./part-799-response.json'); console.log(JSON.stringify(r["DataCatalog"], null, 2))"

This variation changes output inspection rather than adding another infrastructure concept. Keep the raw JSON while developing a query so a narrow projection does not hide an error or unexpected field.

Common mistake

Deletion and stop operations can be irreversible or blocked by dependencies. Capture the resource identifier and current configuration before running the final command.

Cleanup

# This operation is read-only, operational, or needs resource-specific rollback.
# Re-read the command output before changing shared infrastructure.
rm -f part-799-request.json part-799-response.json part-799-payload.bin part-799-debug.log

Local request and response files may contain account IDs, ARNs, names, or service configuration. Remove them when the lab is complete and follow dependency-aware cleanup for any AWS resource you created.

Next, we will learn Athena: Delete named query from the CLI.

Official AWS CLI reference