Read rows from database table | Athena

Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters.

Filter Syntax:

?column=eq.value - Equal
?column=neq.value - Not equal
?column=gt.value - Greater than
?column=gte.value - Greater than or equal
?column=lt.value - Less than
?column=lte.value - Less than or equal
?column=like.*pattern* - LIKE (case-sensitive)
?column=ilike.*pattern* - ILIKE (case-insensitive)
?column=in.(a,b,c) - IN list
?column=is.null - IS NULL

Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters. **Filter Syntax:** - `?column=eq.value` - Equal - `?column=neq.value` - Not equal - `?column=gt.value` - Greater than - `?column=gte.value` - Greater than or equal - `?column=lt.value` - Less than - `?column=lte.value` - Less than or equal - `?column=like.*pattern*` - LIKE (case-sensitive) - `?column=ilike.*pattern*` - ILIKE (case-insensitive) - `?column=in.(a,b,c)` - IN list - `?column=is.null` - IS NULL

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

Query parameters

selectstring or nullOptional

Columns to return (comma-separated, e.g., ‘id,name,email’)

orderstring or nullOptional

Order by clause (e.g., ‘created_at.desc’, ‘name.asc’)

limitintegerOptional1-1000Defaults to 100

Maximum number of rows to return

offsetintegerOptional>=0Defaults to 0

Number of rows to skip

Response

Successful Response

datalist of maps from strings to any

Array of row objects

1	{
2	"data": [
3	{
4	"email": "alice@example.com",
5	"id": 1,
6	"name": "Alice"
7	},
8	{
9	"email": "bob@example.com",
10	"id": 2,
11	"name": "Bob"
12	}
13	]
14	}

Authentication

Path parameters

Query parameters

Response

Errors