# Unable to great expectations checkpoint

**URL:** <https://discourse.greatexpectations.io/t/unable-to-great-expectations-checkpoint/1547>\
**Category:** GX Core Support\
**Created:** [January 2, 2024, 1:28pm UTC](https://discourse.greatexpectations.io/t/unable-to-great-expectations-checkpoint/1547 "2024-01-02T13:28:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![alekya](https://avatars.discourse-cdn.com/v4/letter/a/bb73d2/32.png) [@alekya](https://discourse.greatexpectations.io/u/alekya)\
**Post date:** [January 2, 2024, 1:28pm UTC](https://discourse.greatexpectations.io/t/unable-to-great-expectations-checkpoint/1547/1 "2024-01-02T13:28:22Z")

</div>

Below is the sample code and the error corresponding to that:  
Code Snip:  
“id=1  
run\_name=f”{id}"  
run\_time=datetime.datetime.now()  
run\_id = {  
“run\_name”: run\_name,  
“run\_time”: run\_time  
}

query\_filter = “select \* from \<snowflake\_table\> where \<filter\_condition\>”

batch\_request=RuntimeBatchRequest(  
datasource\_name=“my\_spark\_datasource\_config”,  
data\_connector\_name=“default\_runtime\_data\_connector\_name”,  
data\_asset\_name=“my\_data\_asset\_name”,  
runtime\_parameters={  
“query”: query\_filter  
},  
batch\_identifiers={“d”: “batch\_run\_id”}  
)  
expectation\_suite\_name = “dry\_run\_2”

suite = context.add\_or\_update\_expectation\_suite(expectation\_suite\_name)

validator = context.get\_validator(  
batch\_request=batch\_request,  
expectation\_suite\_name=expectation\_suite\_name,  
)

expectation\_code = ‘expect\_column\_values\_to\_be\_in\_set(value\_set= [1, 2, 3, 4, 5, 134, 7, 8, 12, 13, 14, 15, 16, 17, 18, 24, 25, 26, 27, 28, 29, 30, 31, 157, 36, 37, 38, 39, 40, 41, 42, 48, 49, 50, 51, 180, 181, 182, 183, 59, 60, 61, 62, 63, 64, 65, 66, 67, 69, 71, 73, 74, 81, 84, 85, 86, 87, 88, 89, 90, 95, 97, 98, 101, 109, 120, 121, 122, 123], column= “first\_change\_period\_n” , mostly= 1.0)’

s=“validator.”+expectation\_code  
eval(s)  
validator.save\_expectation\_suite(discard\_failed\_expectations=False)

checkpoint\_config = {  
“class\_name”: “SimpleCheckpoint”,  
“validations”: [  
{  
“batch\_request”: batch\_request,  
“expectation\_suite\_name”: expectation\_suite\_name  
}  
],  
“runtime\_configuration”: {  
“result\_format”: {  
“result\_format”: “SUMMARY”,  
“include\_unexpected\_count”: True,  
“include\_element\_count”: True  
}  
}  
}

checkpoint = SimpleCheckpoint(f"{validator.active\_batch\_definition.data\_asset\_name}\_{expectation\_suite\_name}", context, \*\*checkpoint\_config)

checkpoint\_result = checkpoint.run(run\_id=run\_id)"

**Error** :

2024-01-02T13:25:19+0000 - INFO - 1 expectation(s) included in expectation\_suite.  
Calculating Metrics: 0%| | 0/13 [00:00\<?, ?it/s]  
2024-01-02T13:25:19+0000 - INFO - While introspecting columns NoSuchTableError(); attempting reflection fallback  
2024-01-02T13:25:27+0000 - ERROR - Error running action with name store\_evaluation\_params  
Traceback (most recent call last):  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/validation\_operators/validation\_operators.py”, line 478, in \_run\_actions  
action\_result = self.actions[name].run(  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/checkpoint/actions.py”, line 100, in run  
return self.\_run(  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/checkpoint/actions.py”, line 1015, in \_run  
self.data\_context.store\_evaluation\_parameters(validation\_result\_suite)  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/data\_context/data\_context/abstract\_data\_context.py”, line 2169, in store\_evaluation\_parameters  
self.\_compile\_evaluation\_parameter\_dependencies()  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/data\_context/data\_context/abstract\_data\_context.py”, line 4742, in \_compile\_evaluation\_parameter\_dependencies  
expectation\_suite\_dict: dict = cast(dict, self.expectations\_store.get(key))  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/data\_context/store/expectations\_store.py”, line 210, in get  
return super().get(key) # type: ignore[return-value]  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/data\_context/store/store.py”, line 210, in get  
return self.deserialize(value)  
File “/databricks/python/lib/python3.8/site-packages/great\_expectations/data\_context/store/expectations\_store.py”, line 236, in deserialize  
return self.\_expectationSuiteSchema.loads(value)  
File “/databricks/python/lib/python3.8/site-packages/marshmallow/schema.py”, line 756, in loads  
return self.load(data, many=many, partial=partial, unknown=unknown)  
File “/databricks/python/lib/python3.8/site-packages/marshmallow/schema.py”, line 722, in load  
return self.\_do\_load(  
File “/databricks/python/lib/python3.8/site-packages/marshmallow/schema.py”, line 909, in \_do\_load  
raise exc  
marshmallow.exceptions.ValidationError: {‘expectations’: {0: {‘expectation\_type’: [‘expectation\_type missing in expectation configuration’]}}}

---

<div class="post-metadata">

**Author:** ![rachel.house](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/rachel.house/32/236_2.png) [@rachel.house](https://discourse.greatexpectations.io/u/rachel.house)\
**Post date:** [January 3, 2024, 3:42pm UTC](https://discourse.greatexpectations.io/t/unable-to-great-expectations-checkpoint/1547/2 "2024-01-03T15:42:28Z")

</div>

Hi @alekya, thanks for reaching out!

Based on your usage of `RuntimeBatchRequest` and `SimpleCheckpoint`, it looks like you’re using an outdated version of GX. I’d recommend updating to the latest version (currently `0.18.7`) and referencing the following guides to connect to your Snowflake table:

- [Our Quickstart](https://docs.greatexpectations.io/docs/oss/tutorials/quickstart) will help you get started with the GX workflow of connecting to data, building an Expectation, validating data, and running a Checkpoint.
- [This docs page](https://docs.greatexpectations.io/docs/oss/guides/connecting_to_your_data/fluent/database/connect_sql_source_data) will walk you through connecting to a Snowflake Data Source.