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:
get
https://api.production.selectstar.com/v1/bi/dashboards/
{guid}/frequent-dsusers/
Get a list of Frequent Users for a dashboard
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
get
https://api.production.selectstar.com/v1/lineage/
{guid}/?max_depth=20&direction=right&mode=table
Get lineage for a table
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