View Options
Last updated
Last updated
The option list allows you to set view options such as a label and an expiration time. You can include multiple options using a comma-separated list. ()
This syntax is partially supported in .
expiration_timestamp
TIMESTAMP
friendly_name
STRING
description
STRING
labels
ARRAY<STRUCT<STRING, STRING>>
privacy_policy
JSON-formatted STRING
The description and friendly_name options are include into the Comment Clause generated by SnowConvert .
In BigQuery the labels associated with a view can be used to organize and group tables in the database administrative environment, in Snowflake the Tags can be used for the same functionality. But to ensure that the tag exists, SnowConvert will add the corresponding CREATE TAG before the CREATE VIEW if it contains labels. It is important to know that the CREATE TAG
feature requires Enterprise Edition or higher
When an option clause includes elements not supported by Snowflake, An EWI will be added.
The label-to-tag transformation could lead to errors if the Snowflake account is not Enterprise Edition or higher.
: The OPTIONS clause within View is not supported in Snowflake.