Alias name in Snowflake

Question

Can someone please say how to create an alias name for a table in a snowflake?

sample table:
CREATE OR REPLACE TABLE USER.EMPLOYEE(
    EMPNO CHAR(6 ) COLLATE 'en_US-upper-rtrim' NOT NULL,
    FIRSTNME VARCHAR(12 ) COLLATE 'en_US-upper-rtrim' NOT NULL,
    MIDINIT CHAR(1 ) COLLATE 'en_US-upper-rtrim' NULL,
    LASTNAME VARCHAR(15 ) COLLATE 'en_US-upper-rtrim' NOT NULL,
    WORKDEPT CHAR(3 ) COLLATE 'en_US-upper-rtrim' NULL,
    PHONENO CHAR(4 ) COLLATE 'en_US-upper-rtrim' NULL,
    HIREDATE DATE NULL,
    JOB CHAR(8 ) COLLATE 'en_US-upper-rtrim' NULL,
    EDLEVEL SMALLINT NOT NULL,
    SEX CHAR(1 ) COLLATE 'en_US-upper-rtrim' NULL,
    BIRTHDATE DATE NULL,
    SALARY NUMBER(9,2) NULL,
    BONUS NUMBER(9,2) NULL,
    COMM NUMBER(9,2) NULL
);

Alias:

CREATE ALIAS "USER"."EMP" FOR TABLE "USER"." EMPLOYEE"

Answer 1

If you are searching for SYNONYM/ALIAS, they are not supported by Snowflake.

CREATE SYNONYM EMP FOR USER.EMPLOYEE;

Reference: Migrating Oracle Database to Snowflake: Reference Manual - APPENDIX D

Create Synonym

Synonyms are not supported in Snowflake. The references to the Synonyms will be changed for the original Object.

---

Depending on requirements VIEW could be used instead:

CREATE VIEW USER.EMP
AS
SELECT *
FROM  USER.EMPLOYEE;