TopMind Vertica Connector Wrapper
Project description
Customized vertica connector
The Python Wrapper to vertica_python lib for reconnectiong across server nodes
Credentials
vertica_configs - json variable in ENV
connection_info = {"host": <VERTICA_HOST>,
"port": <VERTICA_PORT>,
"backup_server_node": [<SERVER_NODE_1>, <SERVER_NODE_2>, <SERVER_NODE_3>}
user = os.getenv("VERTICA_USER"),
password = os.getenv("VERTICA_PASSWORD")
database = "DWH"
vertica_configs = json.loads(os.getenv("VERTICA_CONFIGS"))
Usage
pip3 install vertica-connector-talenttech
import os
import json
from vconnector.vertica_connector import VerticaConnector
with VerticaConnector(user, password, vertica_configs) as cnx:
cur = cnx.cursor()
sql = "SELECT 1"
cur.execute(sql)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for vertica-connector-talenttech-1.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 64a0dce5a092508018d41b8977a6d49b0d634c3914f199e5c59827640a9a1b17 |
|
MD5 | 6d1cb3d566f913cc445147e37b3bde92 |
|
BLAKE2b-256 | 301235416b4bc190c5f7bf48d02b5074094c8526b903c4aec826838a1c2a8254 |
Close
Hashes for vertica_connector_talenttech-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0c57004f9b241d8be2bdbd32240a5864add209a1c2e1c1e7487781d30fa222bd |
|
MD5 | 42aac288ffa5032d9d08d6146cfe12b4 |
|
BLAKE2b-256 | dbda0c137e9e5014e497ef7c2f71bee060b374c15eeeaf5efebd262a6d57bedd |