-
Notifications
You must be signed in to change notification settings - Fork 39
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 exotism support #234
Comments
@dmaresma you need to add case where cluster by statement can be before columns defenitions. There is main 'table' expression https://github.com/xnuinside/simple-ddl-parser/blob/main/simple_ddl_parser/dialects/sql.py#L1016 it is expect that after table_name should be LP and defcolumn (column description), so you should add here cluster_by statement as a possible variant like table_name cluster_by (or how this statement should be named) |
I can add it on weekends |
I released in version 1.1.0. Have no idea why I'm writing about weekends, when I didn't have any time( |
Hi,
there is CREATE TABLE statement in Snowflake, created by Matillion where the
cluster by
property precedes the table column definition, I have no idea where to start the change.here the acceptance test :
def test_table_inverse_clusterby_and_column_def():
ddl = """CREATE TABLE ${database_name}.MySchemaName."MyTableName" cluster by ("DocProv") (ID NUMBER(38,0) NOT NULL, "DocProv" VARCHAR(2));"""
The text was updated successfully, but these errors were encountered: