Versatile Data Kit SDK plugin provides support for PostgreSQL database and postgres transformation templates.
Project description
This plugin allows vdk-core to interface with and execute queries against a PostgreSQL database.
Usage
Run
pip install vdk-postgres
After this, data jobs will have access to a Postgres database connection, managed by Versatile Data Kit SDK.
If it is the only database plugin installed , vdk would automatically use it. Otherwise, users need to set VDK_DB_DEFAULT_TYPE=POSTGRES as an environment variable or set 'db_default_type' option in the data job config file (config.ini).
For example
def run(job_input: IJobInput):
job_input.execute_query("select 'Hi Postgres!'")
Configuration
Run vdk config-help - search for those prefixed with "POSTGRES_" to see what configuration options are available.
Testing
Testing this plugin locally requires installing the dependencies listed in vdk-plugins/vdk-postgres/requirements.txt
Run
pip install -r requirements.txt
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
Hashes for vdk-postgres-0.0.664990419.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | bc6fad8234e37c2e90099a646fe7e95c9c1c300bd1ee82d4777a8818c35a4493 |
|
MD5 | 0e9cb2b0c4aac3ba7c4638d3bcf28be6 |
|
BLAKE2b-256 | db4425c5e7bf4f8408db5bba76e7eff61f5c3a2a819dbeb7fdbcd9602cf3b980 |