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
get
https://api.production.selectstar.com/v1/bi/explores
/{guid}/related-dashboards/
Get a list of related dashboard used in a  Looker Explore 
Databases/Tables
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/items/
{guid}/?kind=user/
Get a list of all assets tagged as PII

Troubleshooting

FAQ

Last modified 1mo ago