Skip to content

Snowflake: Missing if exists clause in Create resource monitor clause #6822

@moreaupascal56

Description

@moreaupascal56

Search before asking

  • I searched the issues and found no similar issues.

What Happened

Missing an IF EXISTS clause in the CREATE RESOURCE MONITOR statement

ex:

L:   4 | P:  10 |  PRS | Line 4, Position 10: Found unparsable section:
                       | 'CREDIT_QUOTA = 20\n    TRIGGERS\n        ...'

on

CREATE RESOURCE MONITOR IF NOT EXISTS "test"
    WITH CREDIT_QUOTA = 20
    TRIGGERS
        ON 25 PERCENT DO NOTIFY
        ON 50 PERCENT DO NOTIFY
        ON 75 PERCENT DO NOTIFY
        ON 95 PERCENT DO SUSPEND
        ON 100 PERCENT DO SUSPEND_IMMEDIATE
;

I think it is because of the if not exists because in this PR there is no IF EXISTS clause (my bad)

Expected Behaviour

works

Observed Behaviour

How to reproduce

Dialect

snowflake

Version

3.4.0

Configuration

none

Are you willing to work on and submit a PR to address the issue?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions