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
    • 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
  • Basic Information
  • Operational Information
  • Table Tabs

Was this helpful?

  1. Features

Table Page

PreviousSearchNextDatabase Page

Last updated 3 months ago

Was this helpful?

Database tables in Select Star each have their own page where you can explore a variety of information.

This page gives an overview of the information available in three different areas:

Click the links within this page to learn more about specific features.

Basic Information

  • The full table path of the table in the database.

Operational Information

  • Popularity - Calculated by Select Star. This is the # of times queried by # of users over a customizable period of 30-90 days.

  • Table Size - The size of the table and number of rows.

  • Last Update - When the table metadata was last updated. This value does not indicate when the data values were last updated.

  • Last Refreshed - Indicates the most recent time a table was updated based on metadata and query activity. This helps you understand how up-to-date a table is before using it for analysis or reporting. If a table hasn’t been refreshed in a while, it may indicate stale data.

    How it works:

    • For most tables, this reflects the last time the table was modified in your data warehouse, such as when new data was added or structure changes were made.Comment

    • If there’s no direct record of when the table was last modified, Select Star will use the most recent metadata sync timestamp as the Last Refreshed date.

    • The Last Refreshed date is always based on the latest available information and ensures consistency across your datasets.

    Note: Some refresh delays may occur due to ingestion schedules or metadata sync timing.

  • <SQL> - When available, clicking this will show the SQL used to create the table or view.

Video Tutorial: Popularity

Table Tabs

  • Related - This tab has a list of Similar and Related Tables, where Similar Tables are tables that have the exact same table structure as this table, while Related Tables are tables that can be joined to this table.

  • Preview - A sample of data values in this table. This is disabled by default, as Select Star only looks at metadata from your sources. Contact a Select Star representative if you would like to enable this by sending some sample data values.

    • Note: Preview data is not persisted, it is queried each time it is requested.

that have been applied to the table.

A of the table. Descriptions can synced from Snowflake or dbt's function, or you can add them directly in Select Star.

- Subject matter experts for this particular table, capable of answering business and technical questions about the data. These can be assigned by .

Tabs will give you special information about the table data and in the context of your organization.

Columns - The columns in that table, along with any or they have. See how popular individual columns in a table are, as well as which columns are used to join to other tables. Columns can be ordered three ways on a table page. A -> Z, Z -> A, and Ordinal. Click the header to change the order.

- This tab will have an interactive graph to explore of Upstream Sources and Downstream Targets connected to this table, as well all the Downstream Dashboards.

- Recent and popular queries and join conditions you can use to understand .

Top Users - The people or who are most relevant for this table. This is separated into Table Users who have the most queries against this table, and Dashboard Users who have the most views/queries of directly downstream dashboards.

Data Quality - If you have connected as a datasource, or a dbt data source set up, including dbt tests, you will see any monitors or tests that are related to the table. If all tests have passed you will see a green checkmark on the data quality tab, otherwise the red dot will indicate how many tests / monitors have failed.

- Anyone with a Select Star account can post or comments on this dataset, which are then searchable.

✨
Tags
description
persist_docs
Business and Technical Owners
Admins and Data Managers
how the data is used
descriptions
Tags
Lineage
Queries & Joins
how the data is used
service accounts
Monte Carlo
Discussion
questions
Basic Information
Operational Information
Table Tabs
Table tabs in Select Star