View Options

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

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. (BigQuery SQL Language Reference View Options)

This syntax is partially supported in Snowflake.

Grammar Syntax

OPTIONS(view_option_list [,...])

view_option_list :=
  NAME = value

NAME	Value	Supported
expiration_timestamp	TIMESTAMP
friendly_name	STRING
description	STRING
labels	ARRAY<STRUCT<STRING, STRING>>
privacy_policy	JSON-formatted STRING

Sample Source Patterns

Description & Friendly_name:

The description and friendly_name options are include into the Comment Clause generated by SnowConvert .

Input Code:

BigQuery

IN -> BigQuery_01.sql

CREATE VIEW my_view
OPTIONS (
  description="This is a view description",
  friendly_name="my_friendly_view"
) AS
SELECT column1, column2
FROM my_table;

Output Code:

Snowflake

OUT -> BigQuery_01.sql

CREATE VIEW my_view
COMMENT = '{ "description": "This is a view description", "friendly_name": "my_friendly_view", "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "bigquery",  "convertedOn": "03/25/2025",  "domain": "test" }}'
AS
SELECT column1, column2
FROM
 my_table;

Labels:

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

Input Code:

BigQuery

IN -> BigQuery_01.sql

CREATE VIEW my_view 
OPTIONS(
    labels=[("label1", "value1"), ("label2", "value2")]
)
AS
SELECT column1, column2
FROM table1;

Output Code:

Snowflake

OUT -> BigQuery_01.sql

CREATE TAG IF NOT EXISTS "label1";
CREATE TAG IF NOT EXISTS "label2";

CREATE VIEW my_view
WITH TAG( "label1" = "value1","label2" = "value2" )
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "bigquery",  "convertedOn": "03/26/2025",  "domain": "test" }}'
AS
SELECT column1, column2
FROM
  table1;

Unsupported Options:

When an option clause includes elements not supported by Snowflake, An EWI will be added.

Input Code:

BigQuery

IN -> BigQuery_01.sql

CREATE VIEW my_view
OPTIONS (
  expiration_timestamp=TIMESTAMP "2026-01-01 00:00:00 UTC",
  privacy_policy='{"aggregation_threshold_policy": {"threshold": 50, "privacy_unit_columns": "ID"}}'
) AS
SELECT column1, column2
FROM my_table;

Output Code:

Snowflake

OUT -> BigQuery_01.sql

CREATE VIEW my_view10
!!!RESOLVE EWI!!! /*** SSC-EWI-BQ0001 - SNOWFLAKE DOES NOT SUPPORT THE OPTIONS: EXPIRATION_TIMESTAMP, PRIVACY_POLICY ***/!!!
OPTIONS(
  expiration_timestamp=TIMESTAMP "2026-01-01 00:00:00 UTC",
  privacy_policy='{"aggregation_threshold_policy": {"threshold": 50, "privacy_unit_columns": "ID"}}'
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "bigquery",  "convertedOn": "03/26/2025",  "domain": "test" }}'
AS
SELECT column1, column2
FROM
  my_table;

Known Issues

• The label-to-tag transformation could lead to errors if the Snowflake account is not Enterprise Edition or higher.

Related EWIs

1. SSC-EWI-BQ0001: The OPTIONS clause within View is not supported in Snowflake.