dconnect
Power your data connections with python and query with dconnect
dconnect is a lightweight data source connector wrapper for different databases, User can also perfom queries and will get data.
Available datasources campactibility:
sqlLite, MySQL, SQL Server, Azure SQL DB, PostgreSQL, Redshift, Snowflake, Clickhouse, Oracle, IBM_Db, Vertica, MongoDB, AWS S3 Bucket, GoogleSheets, Elasticsearch, Google Analytics, Neo4j
Installation
Installation from Git
Clone repository using below command
git clone https://github.com/nit567esh/dconnect.git
Go to python package folder and use below command to install the package into library location:
$ cd <pkg_directory>
$ python3 setup.py install
Installation from Pypi
Install directly from Pypi using below command
pip install dconnect
or
python3 -m pip install dconnect
Usages
Functions: 1. See available connection IDs
>>> import connection as c
>>> c.conids()
2. Connect using a conid
>>> con = c.connect('<conid-string>')
2. Run SQL quries incase on Relational DBs/DWs connection object & get data into pandas
>>> df = c.runsql(con,'<Sql-Query>')
Examples:
1. For Relational DBs/DWs
>>> con = c.connect('redshift_<host>_<database>')
>>> df = c.runsql(con,'select top 10 * from edw.dim_product')
Note - Same is applicalble for the following list of DBs: MySQL, SQL Server, Azure SQL DB, PostgreSQL, Redshift
Todos
- Google Adwords, Mixpanel, Sisense integrations and many more