Working with views in Snowsight¶

You can work with views, materialized views, and semantic views in SQL or in Snowsight. For details about the available SQL commands for working with views, see Table, view, and sequence commands.

For any Snowflake view, you can open Data » Databases and search for or browse to the view. Select the view to explore details about the view, the columns defined in the view, and preview the data in the view.

You must have the relevant privileges to access and manage the view, materialized view, or semantic view 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 Use Snowsight to set 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 More options » Edit.

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

  • To transfer ownership of the view to another role, select More options » 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.

Note

If your view is complex, you might not see a data preview. Snowsight queries the view for the data preview and waits for up to 300 seconds for results to be returned. If the query takes longer than 300 seconds to complete, Snowsight cancels the query and displays no preview data.

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.

Language: English