LogoLogo
About UsCustomersResourcesGet Started for Free
  • What is Select Star?
  • 🏁Getting Started
    • 1. Data Source Setup
    • 2. Mark Service Accounts
    • 3. Hide Unwanted Datasets
    • 4. Invite Owners
    • 5. Add Documentation
    • Next Steps
  • 🔄Integrations
    • Snowflake
      • Using Key Pair Authentication
      • Using Password Authentication
      • Snowflake Tag Sync
      • Snowflake Key Pair Rotation
      • Cortex Analyst (beta)
    • Databricks
      • Databricks on AWS
      • Databricks on Azure
    • BigQuery
    • AWS Redshift
      • Manual setup
    • Microsoft SQL Server / MS SQL (beta)
      • Query Logs
    • MySQL (beta)
      • Query Logs
    • Oracle (beta)
      • Query Logs
    • Salesforce (beta)
    • DB2 (beta)
    • PostgreSQL
      • AWS Aurora PostgreSQL
      • AWS RDS PostgreSQL
      • PostgreSQL on-prem
    • AWS Glue (beta)
    • dbt
      • dbt Cloud
      • dbt Core (open source)
      • dbt Tags
      • dbt Tests
      • dbt docs Sync
        • Github dbt docs Sync
        • Bitbucket dbt docs Sync
      • dbt Impact Report
      • dbt Project Dependencies
    • Apache Airflow (beta)
    • Tableau
      • Tableau Cloud
      • Tableau Server
    • PowerBI
    • Looker
    • Metabase
    • Fivetran (beta)
    • Mode
    • Sigma Computing
    • Sisense / Periscope (beta)
    • Looker Studio (beta)
    • ThoughtSpot
    • QuickSight (beta)
      • Event Logs
    • Hex (beta)
    • Slack
    • Monte Carlo
    • Private Network
    • Request an Integration
  • ✨Features
    • Search
    • Table Page
    • Database Page
    • Dashboard Page
    • Data Lineage
    • Entity Relationship Diagram (ERD)
    • Queries & Joins
    • Tags
    • Teams
    • Discussion
    • Downstream Notifications
    • Documentation
      • Pages
      • Metrics
        • Metrics Generation
      • Glossary
    • Automated Documentation
    • User Analytics
    • Chrome Extension
      • Organization-wide install
    • Source Tables
    • Cost Analysis
    • Schema Change Detection
    • AI Features & Settings
      • Ask AI Chatbot
    • Request a Feature
  • 🧭Data Discovery
    • Where's my data?
    • Where's my dashboard?
    • How can I get the full context of this data?
    • My dashboard looks off
    • Change management
    • I'm new to the team
    • I have a data question
  • 🗃️Data Management
    • Add Documentation
      • CSV Metadata Upload
    • Collections
    • Tags
    • Data Ownership
    • Sensitive / PII Data
    • Automated PII Detection
  • 📚Learning Data
    • Getting Started: Looker
    • Getting Started: Mode
    • Getting Started: Tableau
    • Getting Started: Snowflake
    • Getting Started: Databricks
    • Getting Started: Data Warehouse
    • Getting Started: BigQuery
      • Nested Fields
    • Getting Started: Sigma
    • Getting Started: ThoughtSpot
  • 🛠️Data Source Management
    • Manage Data Sources
    • Connect Data Source Users to Select Star
    • Custom Attributes
    • Recent Queries
  • 👥User Management
    • Invite Users
    • Roles & Permissions
    • SAML SSO
    • Importing Roles and Teams (Okta)
    • Policy Based Access Control
    • Account and User Settings
  • 💻Select Star API
    • Overview
    • API Token
    • Getting Started
    • Rich Text Descriptions via API
    • Troubleshooting
    • API Examples
    • API Reference
  • 🔓Security & Compliance
  • ❓FAQ
    • Icon Map
  • 📰Changelog
    • May 20, 2025 - Chrome Extension, Notifications, and More!
    • April 16, 2025 - Semantic Models, AI Metrics, and More!
    • March 12, 2025 - Fivetran Integration, Tableau Updates and More!
    • February 6, 2025 - Collections, Slack App Published, Salesforce Formula Lineage and more!
    • December 10, 2024 - Hex Integration, Impact Score & Snowflake Key Pair Authentication!
    • November 13, 2024 - New Navigation, Airflow and More!
    • September 30, 2024 - Upstream Data Quality Issue Tracking & 5 New Integrations!
    • August 30, 2024 - Monte Carlo, dbt Cross-Project Lineage
    • July 31, 2024 - Glossary Import, Lineage Updates & more!
    • July 9, 2024 - Lineage Explorer 2.0, Slack AI and Notifications
    • February 29, 2024 - AI Chat, Schema Change Notifications
    • February 23, 2024 - Manual Lineage Creation
    • November 23, 2023 - Bulk AI Documentation
    • October 19, 2023 - Downstream Notifications
    • October 16, 2023 - New Homepage
    • October 13, 2023 - dbt Impact Report
    • Historical Changelogs
  • Security & Compliance
  • System Status
Powered by GitBook
On this page
  • Join Fields
  • Queries & Joins
  • Related Dashboards & Tables
  • Top Users
  • Collections and Tags
  • Popularity
  • Field Usage

Was this helpful?

  1. Data Discovery

How can I get the full context of this data?

PreviousWhere's my dashboard?NextMy dashboard looks off

Last updated 2 months ago

Was this helpful?

Select Star brings together a breadth of contextual information about your datasets in one place.

You can see from one location how a dataset is being used, which other datasets are commonly used in with the data, and who uses the data.

There are a number of different ways to explore the data context, including:

Join Fields

From a table page, you can immediately see columns that are frequently used to join to other columns, identified by the icon.

You can identify columns used to join to other tables from the database page as well, and even filter to show those columns.

Queries & Joins

Popular Queries shows the queries run most frequently on the database, sorted by popularity.

The Popular Joins tab shows the tables that are most frequently joined to the current table.

Recent Queries shows the 50 most recent queries run on that database since the last metadata sync. This can give a broader view of how different people in your organization use this dataset.

On each of these tabs, you can click the Query Name or Join Condition to see a sample query in more detail.

The right sidebar contains helpful information, such as the different tables used in the query and join conditions.

Related Dashboards & Tables

The Related tab on a database table shows other relevant data objects: Related and Similar tables.

Related Tables are those that are frequently used together in SELECT queries.

Similar Tables are those which share a similar or identical structure.

Top Users

The Top Users tab can give a high-level overview of who is using a table or its related dashboards.

Top Table Users are people or accounts who run queries on the table the most.

Dashboard pages also have a Top Users tab, which shows the people who run that specific dashboard most often.

Collections and Tags

Use Collections to organize key assets within Select Star, and Tags to indicate data quality.

Collections are used to group information relevant to a domain, data product, department or project. You can have a Sales or Marketing collection to group information relevant to those departments.

Tags are used to indicate data quality. Mark any datasets or fields as Certified, Sensitive, Deprecated, or any other label you'd use to define the state of the data.

Collections are especially helpful for understanding the context of the data. You can click on a collection and see which other datasets have been determined by data experts in your organization to be in a similar business line.

Tags can help understand which datasets are old and unused, as well as which datasets are actively used.

Learn more about how collections tags work and how to manage tags from the links below.

Popularity

The popularity score is a metric that indicates how popular your data assets are amongst your team in terms of usage and activity. This is measured across all your data sources taking as a reference assets of the same type. These types are Tables, Columns, Dashboards, Fields and Queries.

Field Usage

With Field Usage labels in Select Star, now you can identify how the column is used in the downstream object, either table, view or dashboard.

When showing you column-level lineage for your data assets, the following labels are visible:

  • As Is - This label is used when a Field has been replicated.

  • Aggr - This label is used when a Field is aggregated. Ex. if used in count, avg, etc.

  • Transformed - This label is used when a Field has been transformed. Ex. if used in to_varchar, etc.

  • Filter - This label is used when a Field has been used as a filter. Ex. if used in where clause.

How does it work?

For a given table, if a column is used in a downstream table or a dashboard, Select Star identifies the lineage of the column, and applies the appropriate label.

For the example shown below, CUSTOMERS table is one of the tables used to create the view CITY_FIELDS, and column total_transactions is created by applying a count on the customer_id column.


CREATE VIEW CITY_FIELDS AS
SELECT
  ...
  TOTAL_TRANSACTIONS,
  ...
FROM
  ( SELECT
      ...
      COUNT(customers.CUSTOMER_ID) AS TOTAL_TRANSACTIONS
    FROM OLIST.DATASETS.CUSTOMERS ) customers
        .
        .
        .
        .
        

Thus when viewing the column-level lineage, for that view, Select Star shows the label Aggr.

The tab can be especially helpful for new Analysts joining the organization who want to understand how a dataset is used.

The Top Dashboard Users are the people who most frequently run the connected with this table.

You can use the popularity score to filter and sort assets in table views across our Platform. When looking at popularity, bear in mind that service accounts are not considered for the popularity score. Make sure you in settings do remove them from our calculations.

🧭
Queries & Joins
Collections
Tags
Mark Service Accounts
Downstream Dashboards
Join Fields
Queries & Joins
Related Dashboards & Tables
Top Users
Tags
Popularity
Field Usage (beta)
Related Tables
Similar Tables
Field Usage label showing Source Field is used as an Aggregate
Filtering by popularity on a
Database page