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
- Windows 10 , Debian , BSD these are the supported platform
- Python version >= 3.8
- ddl_compare can be installed using pip
pip install sondesh
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 .
- Just Open the Terminal
- type sondesh
- VOALAA !!!!!
- Integration to remote file system to load .sql from there and parse it
- Integration with data-catalogues like spark catalogue or hive metastore and compare ddl.