athena_create_cloudtrail_table

Create an Athena table for CloudTrail logs using partition projection. Specify AWS region, CloudTrail bucket, and output bucket to organize query results effectively.

Instructions

Create an Athena table for CloudTrail logs with partition projection.

<IMPORTANT>
Before using this tool ask the user for OUTPUT bucket, unless it is provided.
This is necessary to create the table correctly. If the API fails, interrupt the process and ask the user for the OUTPUT BUCKET.
</IMPORTANT>

Parameters:
  aws_region (str): The AWS region - use 'us-east-1' if not specified.
  cloudtrail_bucket (str): The S3 bucket for CloudTrail logs - you can retrieve it using the 'cloudtrail_describe_trails' tool.
  is_org_trail (bool): Indicates if the trail is for the organization.
  account_id (str): Your AWS account ID - you can retrieve it.
  database (str): Athena database name to be used.
  output_bucket (str): Ask the user if not specified, S3 bucket URI (e.g. 's3://my-athena-query-results/') for query results - different from cloudtrail_bucket.

Returns:
  str: An empty result if successful, or an error message if there was an issue.

Input Schema

Name	Required	Default
`account_id`	Yes
`aws_region`	Yes
`cloudtrail_bucket`	Yes
`database`	No	default
`is_org_trail`	Yes
`output_bucket`	Yes

Input Schema (JSON Schema)

{
  "properties": {
    "account_id": {
      "title": "Account Id",
      "type": "string"
    },
    "aws_region": {
      "title": "Aws Region",
      "type": "string"
    },
    "cloudtrail_bucket": {
      "title": "Cloudtrail Bucket",
      "type": "string"
    },
    "database": {
      "default": "default",
      "title": "Database",
      "type": "string"
    },
    "is_org_trail": {
      "title": "Is Org Trail",
      "type": "boolean"
    },
    "output_bucket": {
      "title": "Output Bucket",
      "type": "string"
    }
  },
  "required": [
    "aws_region",
    "cloudtrail_bucket",
    "is_org_trail",
    "account_id",
    "output_bucket"
  ],
  "title": "athena_create_cloudtrail_tableArguments",
  "type": "object"
}

AWS‑IReveal‑MCP

athena_create_cloudtrail_table

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from AWS‑IReveal‑MCP

Related Tools