diff options
Diffstat (limited to 'sqlglot/dialects/snowflake.py')
-rw-r--r-- | sqlglot/dialects/snowflake.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/sqlglot/dialects/snowflake.py b/sqlglot/dialects/snowflake.py index 148b6d8..d488d7d 100644 --- a/sqlglot/dialects/snowflake.py +++ b/sqlglot/dialects/snowflake.py @@ -167,6 +167,8 @@ def _parse_convert_timezone(args: t.List) -> exp.Expression: class Snowflake(Dialect): + # https://docs.snowflake.com/en/sql-reference/identifiers-syntax + RESOLVES_IDENTIFIERS_AS_UPPERCASE = True NULL_ORDERING = "nulls_are_large" TIME_FORMAT = "'YYYY-MM-DD HH24:MI:SS'" @@ -283,11 +285,12 @@ class Snowflake(Dialect): "NCHAR VARYING": TokenType.VARCHAR, "PUT": TokenType.COMMAND, "RENAME": TokenType.REPLACE, + "SAMPLE": TokenType.TABLE_SAMPLE, "TIMESTAMP_LTZ": TokenType.TIMESTAMPLTZ, "TIMESTAMP_NTZ": TokenType.TIMESTAMP, "TIMESTAMP_TZ": TokenType.TIMESTAMPTZ, "TIMESTAMPNTZ": TokenType.TIMESTAMP, - "SAMPLE": TokenType.TABLE_SAMPLE, + "TOP": TokenType.TOP, } SINGLE_TOKENS = { |