Used with Great_Expectations to store validation results in an Oracle Database.
Project description
ge-store-validations-oracle-plugin
Steps to use the OracleStoreValidationResultsAction from the plugin
Install this plugin by pasting store_validations_oracle.py from great_expectations/plugins in your corresponding great_expectations/plugins folder.
-
Install the plugin by
pip install store-validations-oracle
. You can putstore-validations-oracle
in the requirements.txt file for CI/CD operations. -
In your required
checkpoint
, add the following action to your checkpoint.yml
file.
- name: store_validations_oracle
action:
class_name: OracleStoreValidationResultsAction
module_name: store_validations_oracle.store_validations_oracle
username: ${USERNAME}
password: ${PASSWORD}
hostname: ${HOSTNAME}
port: ${PORT}
service_name: ${SERVICE_NAME}
table_name: ${TABLE_NAME}
-
In your uncommited/config_variables.yml file or if you are using environment variables, add the following variables related to the Oracle Database account:
- USERNAME
- PASSWORD
- TABLE_NAME
Either:
- HOSTNAME
- PORT (defaults to 1521)
- SERVICE_NAME (defaults to ORCL)
Or:
- CONNECTION_STRING
-
If you already have a given table in oracledb, make sure table has below schema.( If you don't have table script will create one , with required schema. )
CREATE TABLE TABLE1
(
BATCH_KEY VARCHAR2(100) NOT NULL
, META CLOB
, EVALUATION_PARAMETERS CLOB
, STATISTICS CLOB
, SUCCESS VARCHAR2(10)
, RESULT CLOB
);
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
Hashes for store_validations_oracle-0.1.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2575d624fe44f3c87b57cac7163aed1ad5a68f83f1c2046b346aae52d19777a4 |
|
MD5 | 0837cddfe688c469dd8683758d7986d3 |
|
BLAKE2b-256 | 93777f162d341258defa017b28ff9e51a4f59d9041b34805e8959dff2297153a |
Hashes for store_validations_oracle-0.1.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2da7f0be73d1aa0c88292218a9cd65efc71a2d97112010504064985b48b27b4a |
|
MD5 | 9846bb76fcc621fa8d1f1659340dff9f |
|
BLAKE2b-256 | 5febaac74a6b4bcf7cd33826c23a1e4560d22317e1899f5fbc2398ee07b646bf |