![]() By default, the role that executes the CREATE VIEW statement owns Inherit any future grants defined for the object type in the schema. The parameter copies all privileges, except OWNERSHIP, from the existing view to the new view. Retains the access permissions from the original view when a new view is created using the OR REPLACE clause. The tag value is always a string, and the maximum number of characters for the tag value is 256.įor details about specifying tags in a statement, refer to Tag Quotas for Objects & Columns. Specifies the tag name and the tag string value. Specifies the row access policy to set on a view. ROW ACCESS POLICY policy_name ON ( col_name ) If the USING clause is omitted, Snowflake treats the conditional masking policy as a normal When a query is made on the first column. The additional columns specify the columns to evaluate to determine whether to mask or tokenize the data in each row of the query result The first column in the list specifies the column for the policy conditions to mask or tokenize the data and must match theĬolumn to which the masking policy is set. Specifies the arguments to pass into the conditional masking policy SQL expression. Specifies the masking policy to set on a column. For example, the column names are required in the following case:Ĭomments are particularly helpful when column names are cryptic. If any of the columns in the view are based on expressions (not just simple column names), then you must supplyĪ column name for each column in the view. (You do not need to specify the data types of the columns.) Include a column list that specifies the column names and (if needed) comments about If you want to change the name of a column or add a comment to a column in the new view, See Recursive Views (Non-materialized Views Only) and the recursive view examples below.ĭefault: No value (view is not recursive, or is recursive only by using a CTE) column_list For more information about recursive views in general, and the RECURSIVE keyword in particular, Specifies that the view can refer to itself using recursive syntax without necessarily using a CTE (common tableĮxpression). If you drop the view, you drop the temporary view, and not the view The temporary view in the session, until you drop the temporary view. If you created a temporary view with the same name as another view in the schema, all queries and operations used on the view only affect If you want to avoid unexpected conflicts, avoid naming temporary views after views that already exist in the schema. ![]() If a view is not declared as TEMPORARY, the view is permanent. Views created with any of these keywords appear and behave identically toĪ view created with the TEMPORARY keyword.ĭefault: No value. to prevent errors when migrating CREATE VIEW statements). GLOBAL TEMPORARY) are provided for compatibility with other databases The synonyms and abbreviations for TEMPORARY (e.g. Temporary view and all its contents are dropped at the end of the session. Specifies that the view persists only for the duration of the session that you created it in. For more information about secure views, see Working with Secure Views.ĭefault: No value (view is not secure)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |