Working with views in Snowsight¶

Explore view details in Snowsight¶

After opening a view in Snowsight, you can do the following:

• Identify the type of view and when the view was last created. Hover over the time details to see the exact creation date and time.

• Review the SQL definition of the view on the View Details or Semantic View Details tab.

• Manage privileges for the view in the Privileges section of the View Details or Semantic View Details tab. To manage privileges, see Manage object privileges with Snowsight.

• For views and materialized views, review the name, type, ordinal (order of the column in the view), tags, and masking policies applied to the view on the Columns tab.

  To add tags and masking policies to a view, see Create and assign tags.

• For semantic views, you can view details about the logical tables, relationships, facts, dimensions, and metrics by selecting the Semantic Information tab.

Manage a view in Snowsight¶

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

• To edit the view name or add a comment, select » Edit.

• To drop the view, select » Drop.

• To transfer ownership of the view to another role, select » Transfer Ownership.

• To edit a semantic view, select the Semantic Information tab, and select Edit in Cortex Analyst.

Preview data in a view¶

For views and materialized views, you can preview up to the first 100 rows of a view on the Data Preview tab for the view.

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