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

SQL Parser Does Not Understand Snowflake Stages #1013

Closed
ghost opened this issue Aug 12, 2022 · 3 comments
Closed

SQL Parser Does Not Understand Snowflake Stages #1013

ghost opened this issue Aug 12, 2022 · 3 comments
Assignees
Labels
area:integration/airflow openlineage-airflow area:integration/sql kind:bug Something isn't working tool:snowflake Snowflake

Comments

@ghost
Copy link

ghost commented Aug 12, 2022

Receiving the following error in Airflow when trying to create a Snowflake stage:

[2022-08-12, 04:33:44 UTC] {__init__.py:27} ERROR - SQL parser failed: sql parser error: Expected an object type after CREATE, found: STAGE
@merobi-hub
Copy link
Collaborator

Hello, thanks for opening an issue and welcome to the community! We'll respond as soon as possible. In the meantime, we hope you'll join us on Slack if you haven't already: http://bit.ly/OpenLineageSlack.

@ghost
Copy link
Author

ghost commented Aug 12, 2022

An example of failing SQL:

CREATE STAGE IF NOT EXISTS MY_SCHEMA.MY_STAGE
      URL='gcs://my-bucket/my-parquet-files'
      FILE_FORMAT=(TYPE=PARQUET, TRIM_SPACE=TRUE)
      COPY_OPTIONS=(MATCH_BY_COLUMN_NAME=CASE_INSENSITIVE)
      storage_integration = MY_GCS_INTEGRATION

@pawel-big-lebowski
Copy link
Contributor

Related PR in sqlparser-rs sqlparser-rs/sqlparser-rs#833

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area:integration/airflow openlineage-airflow area:integration/sql kind:bug Something isn't working tool:snowflake Snowflake
Projects
Status: Done
Development

No branches or pull requests

5 participants