Create View

In this section, you could find information about Oracle Views and their Snowflake equivalent. The syntax of subquery used to create the view can be found in the SELECT section

Create view

-- Oracle 
CREATE OR REPLACE VIEW view1 as select * from schema1.table1;

-- Snowflake
/**** WARNING: MISSING DEPENDENT OBJECT "schema1.table1" ****/
CREATE OR REPLACE VIEW PUBLIC.view1
AS
select * from schema1.table1;

The following clauses for Create View are removed:

• No Force/ Force

• Edition Clause

• Sharing Clause

• Default collation

• Bequeath clause

• Container clause

-- Oracle 
CREATE OR REPLACE
NO FORCE
NONEDITIONABLE
VIEW schema1.view1
SHARING = DATA
DEFAULT COLLATION collation_name
BEQUEATH CURRENT_USER
as select * from schema1.table1
CONTAINER_MAP;

-- Snowflake
/**** WARNING: MISSING DEPENDENT OBJECT "schema1.table1" ****/
CREATE OR REPLACE VIEW schema1.view1
AS
select * from schema1.table1;

Alter View

Alter is not supported by SnowConvert yet.

Drop View

The CASCADE CONSTRAINT clause is not supported yet.

-- Oracle
DROP VIEW schema1.view1;

DROP VIEW schema1.view1 CASCADE CONSTRAINT;

-- Snowflake
DROP VIEW schema1.view1;

DROP VIEW schema1.view1 CASCADE;
-- ** MSC-ERROR - MSCEWI1001 - UNRECOGNIZED TOKEN ON LINE 18 OF THE SOURCE CODE. **
--                                 CONSTRAINT