Simple DDL Parser to parse SQL (HQL, TSQL, AWS Redshift, BigQuery, Snowflake and other dialects) ddl files to json/python dict with full information about columns: types, defaults, primary keys, etc. & table properties, types, domains, etc.
MIT License
Bot releases are hidden (Show)
Published by xnuinside over 2 years ago
Improvements:
Published by xnuinside over 2 years ago
v0.26.2
Fixes:
Improvements:
Published by xnuinside over 2 years ago
Fixes:
Published by xnuinside over 2 years ago
Published by xnuinside over 2 years ago
v0.25.0
CREATE TABLE [dbo].[TO_Requests](
[Request_ID] [int] IDENTITY(1,1) NOT NULL,
[user_id] [int]
In output you will have names like 'dbo' and 'TO_Requests', not '[dbo]' and '[TO_Requests]'.
Published by xnuinside almost 3 years ago
Published by xnuinside almost 3 years ago
Published by xnuinside almost 3 years ago
v0.23.0
Big refactoring: less code complexity & increase code coverage. Radon added to pre-commit hooks.
PostgreSQL:
Published by xnuinside almost 3 years ago
v0.22.6
Published by xnuinside almost 3 years ago
v0.22.4
Published by xnuinside almost 3 years ago
v0.22.1
Published by xnuinside almost 3 years ago
v0.22.0
I started to add partial support for BigQuery
Pay attention: previously they parsed somehow, but in incorrect structure.
Published by xnuinside about 3 years ago
Published by xnuinside about 3 years ago
v0.20.0
Published by xnuinside about 3 years ago
Published by xnuinside about 3 years ago
Published by xnuinside about 3 years ago
v0.19.5
Fixes:
1. Fixed issues with COMMENT statement in column definitions. Added bunch of tests, now they expect working ok.
DDL like:
CREATE EXTERNAL TABLE test (
job_id STRING COMMENT 't# est | & * % $ // * 6 % !'
)
STORED AS PARQUET LOCATION 'hdfs://test'
Now parsed valid.
Published by xnuinside about 3 years ago
Added support for CREATE .. CLONE with same behaviour as CREATE .. LIKE
Added support for CREATE .. CLONE for schemas and database - displayed in output as {"clone": {"from": ... }}
CREATE TABLE .. CLUSTER BY ..
CONSTRAINT .. [NOT] ENFORCED (value stored in 'primary_key_enforced')
Published by xnuinside about 3 years ago
Supported Redshift statements: SORTKEY, DISTSTYLE, DISTKEY, ENCODE
CREATE TEMP / TEMPORARY TABLE
syntax like with LIKE statement:
create temp table tempevent(like event);
Published by xnuinside over 3 years ago
TABLESPACE user_data ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE