Skip to main content

Snowflake Documentation

Tables

You can check the current information for each table in the metastore type for a selected workspace and metastore from the Tables tab. The following details are shown:

  • Users accessing the tables

  • Number of applications accessing the tables

  • Number of partitions in a table

  • Types of applications accessing the tables

  • Table metadata

  • Table size

  • Tables running in (hot, warm, cold, and unknown states)

  • Total number of tables in a cluster

  • Recommendations and insights for the table

Viewing table details
  1. From the Unravel UI, go to the Data > Tables.

  2. From the Metastore Type drop-down, select Snowflake.

  3. From the Account Id drop-down, select an account Id.

    A list of tables is displayed with the following metadata. The total tables for the selected cluster and metastore are displayed on the left datapage-total-tables.png. You can click the Download CSV download-csv.png icon to export a list of tables in a CSV format. You can download a maximum of up to 1000 tables.

    Click column-setting.png in the table header to add or remove the columns in the table.

    Metadata

    Description

    Dataset

    Name of the dataset.

    Table

    Name of the table.

    Table Type

    Type of the table.

    Created

    Date and time when the table was created. Hover over to view the source of the table and the last updated time of this field.

    Latest Access

    Date and time when the table was last accessed. Hover over to view the source of the table and the last updated time of this field

    Size

    Size of the table.

    Apps

    The type of app accessing the tables. Hover over to view various apps accessing the tables and the last updated time of this field.

    Users

    Number of users accessing the table.

    More Info

    Click View.png to access more information about the selected table.

  4. Select the checkbox corresponding to a table for which you want to view the details. The following graphs are updated based on the selection:

    tables_checkbox.png
    • Users: This graph plots the number of users who access the tables on a given day.

      Data_Users.png
    • Apps: This graph plots the number of applications that access the tables on a given day.

      Data_Apps.png
    • Size: This graph plots the table size on a given day.

      Data_Size.png
Search and filter tables

In the Search box, you can enter the name of the table and click search.png, the corresponding tables are displayed.

To filter the tables using the heat map labels and table events, do the following:

  1. From the Data page, go to Tables > Table state section.

  2. From the Table State on the left, select any of the following heat labels. You can also choose any of the events listed under Table Events.

    The tables matching the corresponding heat labels are listed in the table. You can either select Only option corresponding to a Table state to view the tables in that specific state only, or you can select the checkboxes adjacent to a state.

    Data_Table.png

    Optionally, click column-setting.png on the Table State section to define the heat labels for the table. The Label Tables dialog is displayed.

    datapage-label-tables.png

    Move the color-slider to set the period for the tables to be defined under a specific color-coded heat label. The filter results are displayed. Click Download CSV to download the search results in CSV format. Click View.png in the More Info column for more details about the table.

Viewing the Table details page