-
-
Notifications
You must be signed in to change notification settings - Fork 873
Closed
Labels
bugSomething isn't workingSomething isn't working
Description
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
- I agree to follow this project's Code of Conduct
Metadata
Metadata
Assignees
Labels
bugSomething isn't workingSomething isn't working