Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake changes syntax can't be parsed #3730

Closed
achicoine-coveo opened this issue Jul 2, 2024 · 0 comments · Fixed by #3731
Closed

Snowflake changes syntax can't be parsed #3730

achicoine-coveo opened this issue Jul 2, 2024 · 0 comments · Fixed by #3731
Assignees

Comments

@achicoine-coveo
Copy link

Before you file an issue

  • Make sure you specify the "read" dialect eg. parse_one(sql, read="spark")
    Parsing the Snowflake dialect
  • Make sure you specify the "write" dialect eg. ast.sql(dialect="duckdb")
  • Check if the issue still exists on main
    sqlglot==25.4.0
    sqlglotrs==0.2.8

Fully reproducible code snippet
Please include a fully reproducible code snippet or the input sql, dialect, and expected output.

from sqlglot import parse_one
print(parse_one("""
        select 1 from
        some_table changes (information => default) at (timestamp => to_timestamp_tz(''2024-07-01 00:00:00+00:00'')) end (timestamp => to_timestamp_tz(''2024-07-01 14:28:59.999999+00:00''))
""", dialect="snowflake"))
image

Official Documentation
Please include links to official SQL documentation related to your issue.

https://docs.snowflake.com/en/sql-reference/constructs/changes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants