STORAGE.SECURE_VIEW

Target database: Snowflake

STORAGE.SECURE_VIEW allows you to create secure views in Snowflake.

See also:

• Working with Secure Views (Snowflake Documentation)

• CONFIG_ENTITY_DEFAULTS

Usage

STORAGE.SECURE_VIEW: Boolean

Default: false

Notes

STORAGE.SECURE_VIEW can be enabled for views.

Examples

Creating a secure view

Setting STORAGE.SECURE_VIEW to true for a view (e.g. D_TAXI_ZONE):

STORAGE.SECURE_VIEW: true

DDL generated by Agile Data Engine:

CREATE SECURE VIEW publish.D_TAXI_ZONE AS
SELECT ... ;