Overview
Welcome to the Select Star API documentation! Here, you'll find out how you can programmatically interact with your Select Star instance to automate tasks like updating descriptions and tags.
The Overview will explain the more about the purpose of the API.
Learn how to perform Authentication by generating an API token.
Getting Started will walk you through an example end-to-end.
See what Limitations you have on API calls.
Check the Reference for API endpoints and their parameters.
Overview
Video Tutorial
Select Star provides a fully featured webapp that enables you to manage your data catalog metadata, including descriptions and tags.
However, there are times where you may want to read or write catalog metadata using a script, whether that's adding a new column description alongside an ETL job, or bulk-adding tags related to a table name.
The Select Star API is the place to interact programmatically with your organization's metadata. The following endpoints are currently supported:
GET /metadata/:guid/
: fetching metadata (including description and tags) ondatabase metadata
schema metadata
table metadata
column metadata
PATCH /metadata/:guid/
: writing comments todatabase metadata
schema metadata
table metadata
column metadata
GET /lineage/:guid/
: reading lineageGET /tags/:guid/
: reading and writing a tagGET /tables/
for reading and filtering tablesGET /columns/
for reading and filtering columnsGET /databases/
for reading and filtering databasesGET /schemas/
for reading and filtering schemasGET /tags/
for reading and filtering tags
Note that all endpoint paths terminate with a trailing slash. While the API will redirect if the path is missing the trailing slash, unexpected behavior may occur on redirected non-GET
requests.
Limitations
The Select Star API is rate-limited.
Burst limit: 1000 requests allowed per 60 second rolling window.
Sustained limit: 10,000 requests allowed per 24 hour rolling window.
When the rate limit is reached, any further responses will return a body like:
Last updated