如何配置Great Expectations [Validation Result Store] 到Snowflake

huangapple go评论77阅读模式
英文:

How to configure a Great Expectations [Validation Result Store] to Snowflake

问题

在文档中只找到了关于将Great Expectations配置为将验证结果存储到Snowflake数据库的变种,而不是PostgreSQL。我指的是是否有可能直接将验证结果放入Great Expectations在后台创建的新表中。

英文:

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.

答案1

得分: 0

我已完成的工作(从 SLACK GE 频道获得答案)- 在数据库中提前创建了一个名为 ge_validations_store 的表,具有以下 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)

然后,结果被直接存储在那里。

英文:

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.

huangapple
  • 本文由 发表于 2023年3月9日 23:13:40
  • 转载请务必保留本文链接:https://go.coder-hub.com/75686538.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定