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 details about your table are located at the top of the page. |
|
The table details page includes the following tabs:
|
|
The More menu, located in the upper-right corner of the page, lets you do the following:
|
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.