英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论