Retrieve a branch query
Authorization
A service token or OAuth token must have at least one of the following access or scopes in order to use this API endpoint:
Service Token Accesses
read_databases, read_database
OAuth Scopes
| Resource | Scopes |
|---|---|
| Organization | read_databases |
| Database | read_database |
Authorizations
The access token received from the authorization server in the OAuth 2.0 flow.
Path Parameters
Organization name slug from list_organizations. Example: acme.
Database name slug from list_databases. Example: app-db.
Branch name from list_branches. Example: main.
The query ID
Response
Returns a specific branch query
The ID of the query
The database password used for the query
Tags associated with the query
The query fingerprint
When the query started
The type of SQL statement
The keyspace the query ran against
Tables accessed by the query
The username that executed the query
The remote IP address of the client
The number of shard queries executed
The number of rows read
The number of rows affected
The number of rows returned
Total query duration in milliseconds
Error message if the query failed
The normalized SQL statement
Syntax highlighted SQL statement
When the query record was created
When the query record was last updated
Whether the query can be explained
Whether the query was truncated

