MSC-RS0004

"With no schema binding" statement has no equivalent in Snowflake

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

Redshift's documentation for CREATE VIEW includes an optional clause that specifies that the particular view is not bound to the database objects such as tables or functions, nor to those objects that it is referencing. The documentation also clarifies that in such cases that this clause is used, the referenced objects must be qualified with a schema name. This clause allows to create a view and reference objects that might not exist yet. Their existence will be verified once the view is queried, but not at its definition.

However, there is no equivalent command nor obvious workaround to implement this functionality in Snowflake, furthermore, the Snowflake documentation suggests that the views are linked to a specific schema and so are the referenced objects in the view.

This warning is generated to point out this difference in the architecture and to mark as invalid the functionality of the sentence.

Code Examples

Redshift input

CREATE VIEW myevent AS SELECT eventname FROM public.event
WITH NO SCHEMA BINDING;

Snowflake output

CREATE VIEW myevent
AS
SELECT eventname FROM
public.event
----** MSC-WARNING - MSC-RS0004 - WITH NO SCHEMA BINDING STATEMENT IS NOT SUPPORTED IN SNOWFLAKE. **
--WITH NO SCHEMA BINDING
;

Recommendations

• If you need more support, you can email us at [email protected]