Snowflake check if Schema exists

Question

Snowflake doesn't accept T-sql but i'm trying to Create schema If it doesn't exists.

    IF NOT EXISTS (SELECT * FROM SYS.SCHEMA WHERE NAME = 'CBS')
    CREATE SCHEMA 'CBS';

How to do this in Snowflake?

Obviously you’ve read the Snowflake documentation so can you show what you’ve tried and what issue you are facing? — NickW, Aug 24 '21 at 22:34

score 2 · Accepted Answer · answered Aug 25 '21 at 02:19

2

Just use the 'if not exists' syntax:

Create schema if not exists 'cbs';

answered Aug 25 '21 at 02:19

peterb

If the user's primary role lacks privileges to create schemas in the database, this code returns an error. It's therefore not a great way to check if a schema exists. – Clay Mar 08 '23 at 17:33

score 0 · Answer 2 · answered Aug 25 '21 at 08:38

It looks like you're using Matillion ETL to do this in Snowflake, in which case you have two main choices:

This method will simply fail with an error message if the schema already exists

You can parameterize the schema name in the SQL script if you want to avoid hardcoding.

2 Answers2