Links

API Examples

Here are some of the most common use cases of Select Star API. We recommend using the API for understanding multi-level downstream lineage of a table, table/dashboard usage and many such use cases.
Check out the examples below:

BI/Dashboards

To learn more about Dashboard metadata, see Dashboard.
get
https://api.production.selectstar.com/v1/bi/dashboards/
{guid}/frequent-dsusers/
Get a list of Frequent Users for a dashboard

Databases/Tables

get
GET https://api.production.getselectstar.com/v1/tables/
?search_name=Snowflake.NewAdventureWorks.Person.Address&query={guid}
Get GUID for a table using full path of the object
get
https://api.production.getselectstar.com/v1/tables/
?popularity=90-100&order=-popularity&search_name={tablename}&last_queried_on__gte=2022-11-04T0:00:00
Get GUIDs for the tables with popularity over 90% (Top 10 percent of most used tables)
get
https://api.production.getselectstar.com/v1/tables/
?no_popularity&search_name={tablename}&updated_on__gte=2022-07-06T0:00:00
Get GUIDs for the tables with no usage

Lineage

To learn more about data lineage, see Data Lineage.
get
https://api.production.selectstar.com/v1/lineage/
{guid}/?max_depth=20&direction=right&mode=table
Get lineage for a table

Tags

To learn more about Tags, see Tag Management.
To learn about PII tags, see Sensitive PII Data.
The easiest way to get the guid for one specific tag is from the URL:
Get GUID for a tag in the UI
get
https://api.production.selectstar.com/v1/tags/
?types=dbt&updated_on__gte=2022-12-02T0:00:00
Get GUIDs for all dbt tags
get
https://api.production.selectstar.com/v1/tags/items/
{guid}/?kind=user/
Get a list of all assets tagged as PII
Last modified 7d ago