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)

1	from athena import Athena
2
3	client = Athena(
4	api_key="YOUR_API_KEY",
5	)
6	client.databases.execute_sql(
7	asset_id="asset_id",
8	sql="SELECT id, name FROM users WHERE active = true LIMIT 10",
9	)

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	}

Authentication

Path parameters

Request

Response

Errors