Data API Endpoint Reference
SingleStoreDB currently supports the following API endpoints:
API Endpoint URL | Description |
---|---|
Executes a SQL statement without returning result sets; typically used for executing DDL and DML statements for which result sets are not expected, such as | |
Triggers update of the JWKS used by the Data API. Once the JWKS is updated and validated, the Data API will use the corresponding | |
Verifies that the HTTP service is running and connectable. | |
Executes a SQL statement and returns result sets; typically used for the | |
Executes a SQL statement and returns result sets along with the schema; typically used for the | |
Returns the OpenAPI 3.0 specification for this service. |
Note
The difference between /query/rows
and /query/tuples
endpoints lies in how the query results are presented in the JSON format. In addition, the /query/tuples
endpoint offers better performance for queries with large result sets.
The HTTP request to the /ping
endpoint does not require the SingleStore account credentials passed in an Authorization header.