Working with tables in Snowsight

You can work with tables in SQL or using Snowsight. For details about the available SQL commands for working with tables, see Table, View, & Sequence DDL

For any Snowflake table, you can open Data » Databases and search for or navigate to the table. Select the table to do any of the following:

Note

To work with tables in Snowsight, you must use a role with the relevant table privileges.

Explore table details in Snowsight

After opening a table in Snowsight, you can review the table name and the database and schema that contain the table.

Table details shown for a standard table in Snowsight, described in the surrounding text.

You can also review the following details:

  • The type of table

  • The owner role of the table

  • When the table was created. Hover over the time to see the exact date and time.

  • The number of rows in the table

  • The size of the table. For example, 2.5 KB for a very small table.

You can review the SQL definition for the table on the Table Details tab in the Table definition section. The Columns tab provides information about the columns in the table. Use the Search option to find columns by name.

Manage privileges for the table in the Privileges section of the Table Details tab. See Manage object privileges with Snowsight.

Manage a table in Snowsight

You can perform the following basic management tasks for a table in Snowsight:

  • To edit the table name or add a comment, select More options » Edit.

  • To clone the table, select More options » Clone.

  • To drop the table, select More options » Drop.

  • To transfer ownership of the table to another role, select More options » Transfer Ownership.

  • To load data into the table from files, select Load Data.

Preview data in a table

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

Select More options to manipulate the preview data:

  • 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.

Note

The preview requires a warehouse. By default, Snowsight uses the default warehouse for your user profile, or you can select a different warehouse.