Connecting to JDBC databases using python

jdbc.py

import jaydebeapi

username = ''
password = ''

conn = jaydebeapi.connect('com.qubole.jdbc.jdbc41.core.QDriver',
                          'jdbc:qubole://hive/default/db_name?endpoint=https://us.qubole.com',
                          ['', password])

if conn:
    print('Connection with Qubole established.')

cursor = conn.cursor()
query = 'select count(*) cnt from db_name.app'
result = cursor.execute(query)
data = cursor.fetchone()[0]
print(data)
cursor.close()
conn.close()