Execute SQL against database | Athena

Execute a SQL statement against the database. SELECT queries return columns and rows. Non-SELECT statements (CREATE, INSERT, UPDATE, DELETE, ALTER, DROP, etc.) return execution statuses.

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

Request

This endpoint expects an object.

sqlstringRequired

SQL statement to execute

Response

Successful Response

columnslist of strings or null

Column names (populated for SELECT queries)

rowslist of maps from strings to any or null

Row data as objects (populated for SELECT queries)

statuseslist of strings or null

Execution statuses (populated for non-SELECT statements)

Errors

400

Bad Request Error

403

Forbidden Error

404

Not Found Error

422

Unprocessable Entity Error

500

Internal Server Error

501

Not Implemented Error

503

Service Unavailable Error

$	curl -X POST https://api.athenaintel.com/api/v0/databases/asset_id/sql \
>	-H "X-API-KEY: <apiKey>" \
>	-H "Content-Type: application/json" \
>	-d '{
>	"sql": "SELECT id, name FROM users WHERE active = true LIMIT 10"
>	}'

1	{
2	"columns": [
3	"id",
4	"name"
5	],
6	"rows": [
7	{
8	"id": 1,
9	"name": "Alice"
10	},
11	{
12	"id": 2,
13	"name": "Bob"
14	}
15	]
16	}

$	curl -X POST https://api.athenaintel.com/api/v0/databases/asset_id/sql \
>	-H "X-API-KEY: <apiKey>" \
>	-H "Content-Type: application/json" \
>	-d '{
>	"sql": "SELECT id, name FROM users WHERE active = true LIMIT 10"
>	}'

1	{
2	"columns": [
3	"id",
4	"name"
5	],
6	"rows": [
7	{
8	"id": 1,
9	"name": "Alice"
10	},
11	{
12	"id": 2,
13	"name": "Bob"
14	}
15	]
16	}