For AI agents: a documentation index is available at the root level at /llms.txt and /llms-full.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
LoginBook a Demo
  • Getting Started
    • Athena SDK Quickstart
  • Database API
    • Database Filters & CRUD
  • Python Guides
    • Build with Agents
    • Use Models Directly
    • Load Data Frames
    • Upload Files
    • Create Assets
    • Structured Output
    • Long-Running AOP Execution
  • TypeScript Guides
    • Build with Agents
    • Working with Assets
    • Use Models Directly
    • Execute AOPs
    • Sheets API
    • Browser JavaScript (ESM)
    • UI Registry (Assistant.js)
    • Upload Files
    • Create Assets
    • Structured Output
  • API Reference
      • GETCheck database status
      • GETList tables in database
      • GETRead rows from database table
      • POSTInsert rows into database table
      • DELDelete rows from database table
      • PATCHUpdate rows in database table
      • GETGet table schema (columns and types)
      • POSTExecute SQL against database
Logo
LoginBook a Demo
API ReferenceDatabases

List tables in database

Beta
GET
https://api.athenaintel.com/api/v0/databases/:asset_id/data
GET
/api/v0/databases/:asset_id/data
$curl https://api.athenaintel.com/api/v0/databases/asset_id/data \
>     -H "X-API-KEY: <apiKey>"
1{
2  "tables": [
3    {
4      "name": "users",
5      "row_count": 1250,
6      "schema": "public"
7    },
8    {
9      "name": "orders",
10      "row_count": 45320,
11      "schema": "public"
12    },
13    {
14      "name": "products",
15      "row_count": 500,
16      "schema": "public"
17    }
18  ]
19}
Get a list of all tables in the database with optional row counts.
Was this page helpful?
Previous

Read rows from database table

Next
Built with

Authentication

X-API-KEYstring
API Key authentication via header
OR
AuthorizationBearer

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

Path parameters

asset_idstringRequired

Response

Successful Response
tableslist of objects
List of tables in the database

Errors

400
Bad Request Error
403
Forbidden Error
404
Not Found Error
422
Unprocessable Entity Error
501
Not Implemented Error
503
Service Unavailable Error