# Table Page

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

{% embed url="<https://www.loom.com/share/5f3cfb28b2db48fba0a6f23276b060a5?hideEmbedTopBar=true>" %}

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

* [Basic Information](#basic-information)
* [Operational Information](#operational-information)
* [Table Tabs](#table-tabs)

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

<div data-full-width="true"><figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-dfca3e2a2524c7bb1da6c10d63ba2e0f6b48910f%2FScreenshot%202024-07-30%20at%2015.50.18.png?alt=media" alt=""><figcaption></figcaption></figure></div>

## Basic Information

<div data-full-width="true"><figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-e4fac5963aa260fdec432d12d5136cf10d100e82%2FScreenshot%202024-07-30%20at%2015.50.18%20copy.png?alt=media" alt=""><figcaption></figcaption></figure></div>

* The full table path of the table in the database.
* [**Tags**](https://docs.selectstar.com/features/tags) that have been applied to the table.
* A [**description**](https://docs.selectstar.com/data-management/add-documentation) of the table. Descriptions can synced from Snowflake or dbt's [persist\_docs](https://docs.getdbt.com/reference/resource-configs/persist_docs) function, or you can add them directly in Select Star.

## Operational Information

<div data-full-width="true"><figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-88f0b8bc0027bebce198ba10bf6d66dcae44f7a9%2FScreenshot%202024-07-30%20at%2015.52.56.png?alt=media" alt=""><figcaption></figcaption></figure></div>

* [**Business and Technical Owners**](https://docs.selectstar.com/data-management/data-ownership) - Subject matter experts for this particular table, capable of answering business and technical questions about the data. These can be assigned by [Admins and Data Managers](https://docs.selectstar.com/user-management/user-roles).
* **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

{% embed url="<https://www.loom.com/share/c63f6380dac84e3abb4b9a0f027c1ff5?hideEmbedTopBar=true>" %}

## Table Tabs

<div data-full-width="true"><figure><img src="https://3470314135-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MgAiVthA_yg9UXKuhyY%2Fuploads%2Fgit-blob-1319870db0b7e63fe691727fbdcc23b75faca03f%2FMonosnap%20ORDERS%20%7C%20Select%20Star%202024-08-16%2011-27-53.png?alt=media" alt=""><figcaption><p>Table tabs in Select Star</p></figcaption></figure></div>

Tabs will give you special information about the table data and [how the data is used](https://docs.selectstar.com/data-discovery/how-can-i-use-this-data) in the context of your organization.

* **Columns** - The columns in that table, along with any [descriptions](https://docs.selectstar.com/data-management/add-documentation) or [Tags](https://docs.selectstar.com/features/tags) 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.
* [**Lineage**](https://docs.selectstar.com/features/lineage) - 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.
* [**Queries & Joins**](https://docs.selectstar.com/features/queries-and-joins) - Recent and popular queries and join conditions you can use to understand [how the data is used](https://docs.selectstar.com/data-discovery/how-can-i-use-this-data).
* **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.
* **Top Users** - The people or [service accounts](https://docs.selectstar.com/getting-started/mark-service-accounts) 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 [Monte Carlo](https://docs.selectstar.com/integrations/monte-carlo) 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.
* **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.
* [**Discussion**](https://docs.selectstar.com/features/discussion) - Anyone with a Select Star account can post [questions](https://docs.selectstar.com/data-discovery/i-have-a-data-question) or comments on this dataset, which are then searchable.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.selectstar.com/features/table-page.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.