Snowsight - Databases: Table Details

When you select a table in the database object explorer, the table details page appears.

This section provides a brief overview of how to navigate and use the table details page.

Interface

Description

Basic table details

Basic details about your table are located at the top of the page.

Table details tabs

The table details page includes the following tabs:

  • Table Details

  • Columns

  • Data Preview

  • Copy History

More menu

The More menu, located in the upper-right corner of the page, lets you do the following:

  • Edit

    Edit the table name and comment.

  • Clone

    Clone the table.

  • Drop

    Drop the table.

  • Transfer Ownership

    Transfer ownership of the table to another role.

Table Details Tab

The Table Details tab includes the following sections:

  • Table definition

  • Privileges

The Table definition section contains the SQL that was used to initialize the table.

Use the Privileges section to view, grant, and revoke privileges on the table.

Columns Tab

The Columns tab provides a table of columns in the table.

In the upper-right corner of the page, use the Search box to find columns by name.

Data Preview Tab

The Data Preview tab provides a preview of up to the first 100 rows of the table.

Hover over the column headings to do the following:

  • Sort the data in ascending or descending order.

  • Increase or decrease the decimal precision.

  • Show thousands separators in numbers.

  • Display the data in the column as percentages.

The options available to you depend on the type of data in the column.

The preview requires a warehouse. Snowsight uses the default warehouse for your user profile. If you cannot see the expected table content, or if you want to switch warehouses, in the upper-left corner of the preview, select a warehouse.

Copy History Tab

The Copy History tab provides the Copies over time table.

The Copies over time table lets you view up to the last 14 days of the following activity:

  • COPY INTO _<table>_ statements used to load data into the table.

  • Continuous data loading using pipes.

In the upper-right corner of the table, you can use the following filters:

  • Date range

    You can filter by the following ranges:

    • Last day

    • Last 3 days

    • Last 7 days (default)

    • Last 14 days

    • Custom (cannot exceed 14 days)

  • Status

    You can filter by the following statuses:

    • All (default)

    • In progress

    • Loaded

    • Failed

    • Partially loaded

    • Skipped

  • Pipes

    By default, the table includes activity from all pipes in the given date range.

The Copy History tab requires a warehouse. Snowsight uses the default warehouse for your user profile. If you cannot see the copy history, or want to switch warehouses, in the upper-right corner of the preview, select a warehouse.