# \#sql

**URL:** https://discourse.greatexpectations.io/tag/sql/12.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…

---

## [I want to validate the tables which is stored in database](https://discourse.greatexpectations.io/t/i-want-to-validate-the-tables-which-is-stored-in-database/1868)

<div class="topic-metadata">

**Author:** [@aarushi\_sinha](https://discourse.greatexpectations.io/u/aarushi_sinha)\
**Replies:** 1\
**Last updated:** [October 21, 2024, 3:24am UTC](https://discourse.greatexpectations.io/t/i-want-to-validate-the-tables-which-is-stored-in-database/1868 "2024-10-21T03:24:52Z")

</div>

Hi Team, I am trying to setup validation of Doris database using Data Connection option in ‘OtherSQL’ as given in documentation. When I am running a checkpoint: batch\_parameters={“year”: “2024”, “month”: “08”, “day”: …

---

## [Disable caching for SQL Data Source](https://discourse.greatexpectations.io/t/disable-caching-for-sql-data-source/1707)

<div class="topic-metadata">

**Author:** [@achartuni](https://discourse.greatexpectations.io/u/achartuni)\
**Replies:** 0\
**Last updated:** [April 12, 2024, 4:56pm UTC](https://discourse.greatexpectations.io/t/disable-caching-for-sql-data-source/1707 "2024-04-12T16:56:48Z")

</div>

Lately, I am seeing this error pop more often during execution: Test failed with exception: Invalid result values were found when trying to instantiate an ExpectationValidationResult. Invalid result values are likely …

---

## [marshmallow.exceptions.ValidationError: {'name': \['Unknown field.'\]}](https://discourse.greatexpectations.io/t/marshmallow-exceptions-validationerror-name-unknown-field/1693)

<div class="topic-metadata">

**Author:** [@zoe](https://discourse.greatexpectations.io/u/zoe)\
**Replies:** 4\
**Last updated:** [April 12, 2024, 9:58am UTC](https://discourse.greatexpectations.io/t/marshmallow-exceptions-validationerror-name-unknown-field/1693 "2024-04-12T09:58:58Z")

</div>

hi everyone, I just follow the GitHub tutorial sql example to validate query data in Postgres. But get this error when commit ‘results = checkpoint.run(result\_format=result\_format)’. Can anyone help? many thanks~!!

---

## [How to support custom drivers for DB](https://discourse.greatexpectations.io/t/how-to-support-custom-drivers-for-db/1501)

<div class="topic-metadata">

**Author:** [@Aleksei](https://discourse.greatexpectations.io/u/Aleksei)\
**Replies:** 1\
**Last updated:** [January 7, 2024, 10:24am UTC](https://discourse.greatexpectations.io/t/how-to-support-custom-drivers-for-db/1501 "2024-01-07T10:24:23Z")

</div>

Hello! I know that GX is using SqlAlchemy for connection to DB. But what i should do if SQLAlchemy does not support DB and I need to use the driver for DB? For instance, for Vertica DB special driver exists - vertica\_p…

---

## [Unable to connect to datasource due to missing configVariableError](https://discourse.greatexpectations.io/t/unable-to-connect-to-datasource-due-to-missing-configvariableerror/1349)

<div class="topic-metadata">

**Author:** [@gmiguel](https://discourse.greatexpectations.io/u/gmiguel)\
**Replies:** 2\
**Last updated:** [September 1, 2023, 3:00pm UTC](https://discourse.greatexpectations.io/t/unable-to-connect-to-datasource-due-to-missing-configvariableerror/1349 "2023-09-01T15:00:50Z")

</div>

Hi all, I am trying to connect to my MS SQL Server with a connection string, but it is not working. I have the write credentials but I keep getting the error: saying that a config variable ‘word’ is not defined. I don’t…

---

## [Can I filter my data with a SQL query before validation?](https://discourse.greatexpectations.io/t/can-i-filter-my-data-with-a-sql-query-before-validation/1268)

<div class="topic-metadata">

**Author:** [@austin\_gx](https://discourse.greatexpectations.io/u/austin_gx)\
**Replies:** 1\
**Last updated:** [July 14, 2023, 8:53pm UTC](https://discourse.greatexpectations.io/t/can-i-filter-my-data-with-a-sql-query-before-validation/1268 "2023-07-14T20:53:19Z")

</div>

Can I use a SQL query in the “row\_condition” parameter in an expectations use? Is there a function where I can filter through SQL query?