TopMind Vertica Connector Wrapper
Project description
Customized vertica connector
The Python Wrapper to vertica_python lib for reconnectiong across server nodes
Usage
pip3 install vertica-connector-talenttech
import os
import json
from vconnector.vertica_connector import VerticaConnector
user = os.getenv("VERTICA_USER"),
password = os.getenv("VERTICA_PASSWORD")
database = "DWH"
vertica_configs = json.loads(os.getenv("VERTICA_CONFIGS"))
with VerticaConnector(user=user,
password=password,
database=database,
vertica_configs=vertica_configs) as cnx:
cur = cnx.cursor()
sql = "SELECT 1"
cur.execute(sql)
VERTICA_CONFIGS var structure
vertica_configs - json variable in ENV
{"host": <VERTICA_HOST>,
"port": <VERTICA_PORT>,
"backup_server_node": [<SERVER_NODE_1>, <SERVER_NODE_2>, <SERVER_NODE_3>}
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.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 31e3f269ed487db185a73d0f9b8f9beef1f37619c2d27c222490846ac460d3bf |
|
MD5 | 410391a3a1af94b0e273c03a375d7959 |
|
BLAKE2b-256 | 48df244cb43d07bd35da0a38852a7c18dcb5f29999a2a05586987d4b2cbf69e7 |
Close
Hashes for vertica_connector_talenttech-1.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6439d3352eca1d0a71d49d9e30e3bcccae052de37a9daa6a2c530ce0101e9f65 |
|
MD5 | 5a9477945f272b6ee168fb65b76dbaf3 |
|
BLAKE2b-256 | 6819c3da442f25d6077a3ce50610ef12e638f1081ab8d949fff915154283c2fd |