Get table schema (columns and types) | Athena

from athena import Athena
client = Athena(
    api_key="YOUR_API_KEY",
)
client.databases.get_table_schema(
    asset_id="asset_id",
    table_name="table_name",
)

{
  "columns": [
    {
      "data_type": "integer",
      "is_nullable": false,
      "name": "id",
      "default_value": "nextval('users_id_seq'::regclass)"
    },
    {
      "data_type": "character varying",
      "is_nullable": true,
      "name": "name",
      "max_length": 255
    },
    {
      "data_type": "character varying",
      "is_nullable": false,
      "name": "email",
      "max_length": 255
    },
    {
      "data_type": "timestamp with time zone",
      "is_nullable": false,
      "name": "created_at",
      "default_value": "now()"
    }
  ],
  "table_name": "users",
  "schema": "public"
}

Get the schema for a specific table, including column names, types, nullability, and default values. Useful for agent tooling and dynamic form generation.

Authentication

X-API-KEYstring

API Key authentication via header

AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Path parameters

asset_idstringRequired

table_namestringRequired

Response

Successful Response

columnslist of objects

List of columns with their types and constraints

table_namestring

Name of the table

schemastring or nullDefaults to public

Schema containing the table

Authentication

Path parameters

Response

Errors