joereynolds / joereynolds/sql-lint

Snowflake's warehouse & revoke keywords raising an error

Open
#174 3 comments 0 reactions 0 assignees View on GitHub
driver
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.