SQL Analytics API reference

Preview

This feature is in Public Preview. Contact your Databricks representative to request access.

The Databricks SQL Analytics REST API supports services to manage your SQL endpoints and query history.

This article provides an overview of how to use the REST API. Links to each API reference are listed at the end of the article.

For information about authenticating to the REST API, see Authentication using Databricks personal access tokens.

Rate limits

The Databricks REST API supports a maximum of 30 requests/second per workspace. Requests that exceed the rate limit will receive a 429 response status code.

Parse output

It can be useful to parse out parts of the JSON output. In these cases, we recommend that you to use the utility jq. For more information, see the jq Manual. You can install jq on MacOS using Homebrew by running brew install jq.

Some STRING fields (which contain error/descriptive messaging intended to be consumed by the UI) are unstructured, and you should not depend on the format of these fields in programmatic workflows.

Invoke a GET using a query string

While most API calls require that you specify a JSON body, for GET calls you can specify a query string.

To get the details for a SQL endpoint, run:

curl ... https://<databricks-instance>/api/2.0/sql/endpoints/get?id=<endpoint-id>