Getting Started: Data Warehouse

Learn how to connect to your data warehouse to Select Star and retrieve metadata from your datasets. This guide will provide you with the necessary steps to get started.

Click on a database in the left sidebar to see all schemas and tables in it, ordered by Popularity.

Database Page

Search

Use Cmd/Ctrl+F or click the 🔍 icon in the header to search though all items.

Search

Column selection

You can click on the filter icon present on the table header Filters to choose which columns you would like to see and customize your view.

Column selection

Filters

You can use the filters on the right side of the page to filter based on criteria you define.

Filters

Owners

Find datasets which have no Owners assigned, or ones which belong to specific users or teams.

Owners Filter

Tags

Check any of the Tags boxes to show data with those tags applied.

Tags Filter

Popularity

See your most popular and least popular datasets, as well as those with no popularity, documentation, or tags. These filters can help you identify where you need to add documentation or distinguish between excellent and subpar datasets using tags.

Popularity Filter

Column View

Change the Data Type in the dropdown to see all columns in a database. It will show all tables and views by default.

Column View

Filters

When looking at columns, you can do more granular work than the table view, but broader work than viewing an individual table. You can filter based on schema or table in the right sidebar, or find columns of a certain data type.

Column View Filters

Unknown column types are any column types not represented by the other filters. Unless you are using custom type fields, you should not expect to have any.

Join Field

The column-level view will have a filter for columns used to join to other tables.

Column Join Field

There will be a on some columns to indicate they are a join field, this is also visible on the table page.

Explore the database page in more detail by clicking the link below.

Database Page

Table Page

Click on a table or column from the Database page to see detailed information about that table, such as table lineage, common queries run on the table, Downstream Dashboards, and more.

Table Page

Explore the table page in more detail by clicking the link below.

Table Page