search

xnuinside / simple-ddl-parser

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
175 stars 40 forks source link

Feature/fix snowflake #233

Closed dmaresma closed 6 months ago

dmaresma commented 6 months ago

Hi, I hope your are well, sorry to comeback each friday,

here my improvement (most of the time bug fixes)

adding support of CREATE SCHEMA COMPARE cause snowflake allow it.

adding a better support of snowflake file format with dict type of properties a kind of key value for id, strings etc... and dont want manage a bunch of new key word.

remove unnecessary sentence

the extract of the change log

Improvements

  1. Fixed bug with CREATE OR REPLACE SCHEMA.

Snowflake

  1. Fixed bug with snowflake (stage_)fileformat option value equal a single string as FIELD_OPTIONALLY_ENCLOSED_BY = '\"', FIELD_DELIMITER = '|'
  2. improve snowflake fileformat key equals value into dict. type.
xnuinside commented 6 months ago

@dmaresma you contributed a lot, if you want - I can add you as commiter with rights to merge PRs - ping me in telegram, if needed

xnuinside commented 6 months ago

@dmaresma 1.0.3 released and thank you for PR!