Skip to content

Metadata Comparison Toolkit. As of now, V-1.0.0 only consists Comparison of two DDL file ( .sql ) or two DDL statement. You can also parse sql files .

License

Notifications You must be signed in to change notification settings

koustreak/Sondesh

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Project : Sondesh

Maintenance Maintainer PyPI license made-with-python Generic badge
logo.png

Description

Sondesh is the name of my cat . I love him very much so i've decided to name this project after him.

This project is all about a parser and comparator . Question is what it is parsing ?

  • It parse SQL statements , but only DDL statements
  • It supports many sql dialects , example oracle , postgresql , sparksql , hive ..
  • There is a cli app ( cli_app.py ), it compares two DDL statements and show you the differences in terminal

compare_result.png

Dependencies

  • Windows 10 , Debian , BSD these are the supported platform
  • Python version >= 3.8

Installing

  • ddl_compare can be installed using pip
pip install sondesh

Usage

from sondesh import ddl_parser
import pprint

result = ddl_parser.parse_from_file('/home/koushik/sample_ddl.sql')
pprint.pprint(result)

Using the CLI APP .

  1. Just Open the Terminal
  2. type sondesh
  3. VOALAA !!!!!

logo_terminal.png

What Next :

  1. Integration to remote file system to load .sql from there and parse it
  2. Integration with data-catalogues like spark catalogue or hive metastore and compare ddl.

About

Metadata Comparison Toolkit. As of now, V-1.0.0 only consists Comparison of two DDL file ( .sql ) or two DDL statement. You can also parse sql files .

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages