How to Configure the Secure View Layer

Configure the Semantic Layer Settings for a data source.

If configured, the secure semantic view layer and security policy settings will be used to generate CREATE VIEW statements to create a semantic layer that selects data from the generated dynamic tables. One view will be created for each dynamic table.

You can learn more about Snowflake's security policy capabilities here https://docs.snowflake.com/en/user-guide/security-row-intro and https://docs.snowflake.com/en/user-guide/security-column-intro.

1. Enter the Object Type

2. Enter the Root Level Name

The name used for the root view for the semantic layer. This value will be used as a prefix for all nested array views.

This value is required if you choose a type of semantic layer object for this data source.

You do not need to include an underscore at the end of this name. An underscore will be added automatically for all nested output objects.

3. (Optional) Enter the Semantic Layer Deployment Database Name

The name of the database the semantic layer objects will be deployed to.

Explore deployment options to learn more.

4. (Optional) Enter the Semantic Layer Deployment Schema Name

The name of the schema the semantic layer objects will be deployed to.

Explore deployment options to learn more.

5. (Optional) Enter the Primary Row Access Policy Name

The name of the row access policy used for the root level semantic layer object.

6. (Optional) Enter the Optional Parameters

Optional parameters for the root level semantic layer object. This value will be included in the CREATE statement.

Visit https://docs.snowflake.com/en/sql-reference/sql/create-view#optional-parameters to learn more.