joereynolds / joereynolds/sql-lint
Snowflake's warehouse & revoke keywords raising an error
- Dominant language
- TypeScript
- Stars
- 459
- Forks
- 44
- PR merge metrics
- No merged PRs in 30d
Description
Hi, thanks for this linter, it's nice.
## Query 1
`CREATE WAREHOUSE IF NOT EXISTS ...`
### Error
```
[sql-lint: invalid-create-option] Option 'warehouse' is not a valid option, must be one of '["algorithm","database","definer","event","function","index","or","procedure","server","table","tablespace","temporary","trigger","user","unique","view"]'.
```
## Query 2
`revoke usage on warehouse ...`
### Error
```
The query must start with one of Alter,Begin,Call,Create,Declare,Delete,Delimiter,Drop,Else,End,From,Having,If,Insert,Join,Leave,Limit,Replace,Return,Select,Set,Show,Truncate,Update,Use,Where,CommentHash,CommentDash,CommentMultiLin
```
## Environment
* github/super-linter within Github
* lang: Snowflake
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.