# \#expectation-request

**URL:** https://discourse.greatexpectations.io/tag/expectation-request/7.md

[Latest](https://discourse.greatexpectations.io/latest.md) · [Categories](https://discourse.greatexpectations.io/categories.md) · [Tags](https://discourse.greatexpectations.io/tags.md)

---

## [Great expectation is only returning 20 rows of failed records](https://discourse.greatexpectations.io/t/great-expectation-is-only-returning-20-rows-of-failed-records/1991)

<div class="topic-metadata">

**Author:** [@zeeshan.fractal](https://discourse.greatexpectations.io/u/zeeshan.fractal)\
**Replies:** 7\
**Last updated:** [March 14, 2025, 8:41am UTC](https://discourse.greatexpectations.io/t/great-expectation-is-only-returning-20-rows-of-failed-records/1991 "2025-03-14T08:41:26Z")

</div>

Hello Everyone, I’m currently working on a project that uses the Snowflake connector with Great Expectations (version 0.17.23). I’ve set up some validation rules, and my data is failing on several of these. However, eve…

---

## [ETL transformation validation using great expectation](https://discourse.greatexpectations.io/t/etl-transformation-validation-using-great-expectation/1147)

<div class="topic-metadata">

**Author:** [@sd6974](https://discourse.greatexpectations.io/u/sd6974)\
**Replies:** 1\
**Last updated:** [December 6, 2022, 5:32pm UTC](https://discourse.greatexpectations.io/t/etl-transformation-validation-using-great-expectation/1147 "2022-12-06T17:32:58Z")

</div>

Suppose i have a source table and has two columns first name and last name.By applying ETL logic some transformation happens and in the target table it is inserted as “First name Last name” in name column in target table…

---

## [Cross Table Expectations](https://discourse.greatexpectations.io/t/cross-table-expectations/1142)

<div class="topic-metadata">

**Author:** [@alirng](https://discourse.greatexpectations.io/u/alirng)\
**Replies:** 0\
**Last updated:** [November 17, 2022, 5:35pm UTC](https://discourse.greatexpectations.io/t/cross-table-expectations/1142 "2022-11-17T17:35:58Z")

</div>

Currently trying to implement a cross table expectation that will check whether a specific value matches for a given primary key across two tables. Example: table\_1 = \[(a,1,3000), (b,0,2000), (c,0,4000), (d,1,3000)\] …

---

## [Great Expectation Setup with Azure Data Bricks](https://discourse.greatexpectations.io/t/great-expectation-setup-with-azure-data-bricks/1104)

<div class="topic-metadata">

**Author:** [@ramanpandey](https://discourse.greatexpectations.io/u/ramanpandey)\
**Replies:** 0\
**Last updated:** [August 25, 2022, 6:14am UTC](https://discourse.greatexpectations.io/t/great-expectation-setup-with-azure-data-bricks/1104 "2022-08-25T06:14:50Z")

</div>

Hello All, I am looking for the steps to be followed to setup the Great Expectations to my local system- Any Guidance will be helpful

---

## [How to add mulitple checks in single expectation to reduce cost (not in expectation\_suite)](https://discourse.greatexpectations.io/t/how-to-add-mulitple-checks-in-single-expectation-to-reduce-cost-not-in-expectation-suite/1080)

<div class="topic-metadata">

**Author:** [@Rudranil](https://discourse.greatexpectations.io/u/Rudranil)\
**Replies:** 0\
**Last updated:** [July 14, 2022, 2:25pm UTC](https://discourse.greatexpectations.io/t/how-to-add-mulitple-checks-in-single-expectation-to-reduce-cost-not-in-expectation-suite/1080 "2022-07-14T14:25:51Z")

</div>

We are trying to achieve a complex rule check like : “COL\_A\>COL\_B and COL\_C IS NOT NULL and (COL\_D in IN (SELECT COL\_E from another table where main\_table.key=another\_table.key) OR COL\_D is NULL)\*”. There are some poin…

---

## [Unable to run expectation with checkpoint](https://discourse.greatexpectations.io/t/unable-to-run-expectation-with-checkpoint/915)

<div class="topic-metadata">

**Author:** [@pmeh](https://discourse.greatexpectations.io/u/pmeh)\
**Replies:** 0\
**Last updated:** [October 28, 2021, 10:32pm UTC](https://discourse.greatexpectations.io/t/unable-to-run-expectation-with-checkpoint/915 "2021-10-28T22:32:18Z")

</div>

I created expectation using Jupyter notebook and ran it and it worked fine. But when I try to run it while creating a checkpoint, it gives me psycopg2 error. 716 def do\_execute(self, cursor, statement, parameters, …

---

## [Profiling overwriting validations and vice versa](https://discourse.greatexpectations.io/t/profiling-overwriting-validations-and-vice-versa/568)

<div class="topic-metadata">

**Author:** [@Gabbar](https://discourse.greatexpectations.io/u/Gabbar)\
**Replies:** 2\
**Last updated:** [December 18, 2020, 8:02am UTC](https://discourse.greatexpectations.io/t/profiling-overwriting-validations-and-vice-versa/568 "2020-12-18T08:02:55Z")

</div>

Hi background: I am running GE in hosted environment using this - DataContext created during the run. I have two different Jobs - one for Validation (daily) and another for Profiling(weekly/monthly). I am using same S…
