search

shinichi-takii / ddlparse

DDL parase and Convert to BigQuery JSON schema and DDL statements
https://pypi.org/project/ddlparse/
BSD 3-Clause "New" or "Revised" License
87 stars 29 forks source link

Support for Sort Key #59

Open BhuviTheDataGuy opened 4 years ago

BhuviTheDataGuy commented 4 years ago

Im not sure where to mention this. It may be a suggestion or a new feature.

Im RedShift we have SORT KEYs which is equivalent to clustering in BigQuery.

It would be great that the DDLparser detect it.

create table test
(
id int sortkey,
name varchar(10)
);

create table test2 
(
id int,
name varchar(10)
)
sortkey(id);

DDLparse:

print(col.sortkey )

id