0

Is it possible for Great Expectations to configure Validation Result Store to Snowflake database? Found only variant for PostgreSQL in documentation. I mean here possibility to directly put validation result to behind the scenes created a new table by Great Expectations.

unkind58
  • 117
  • 2
  • 11

1 Answers1

0

What I have done (got answer from SLACK GE channel) - I created in advance table (name as ge_validations_store) in the Database with the following

DLL:
         Column         |       Type        | Collation | Nullable | Default 
------------------------+-------------------+-----------+----------+---------
 expectation_suite_name | character varying |           | not null | 
 run_name               | character varying |           | not null | 
 run_time               | character varying |           | not null | 
 batch_identifier       | character varying |           | not null | 
 value                  | character varying |           |          | 
Indexes:
    "ge_validations_store_pkey" PRIMARY KEY, btree (expectation_suite_name, run_name, run_time, batch_identifier)

And after that result were stored directly there.

unkind58
  • 117
  • 2
  • 11