# Great expectation Data Assistant(Missingness) - Unable to fetch results

**URL:** <https://discourse.greatexpectations.io/t/great-expectation-data-assistant-missingness-unable-to-fetch-results/1558>\
**Category:** GX Core Support\
**Created:** [January 9, 2024, 2:05pm UTC](https://discourse.greatexpectations.io/t/great-expectation-data-assistant-missingness-unable-to-fetch-results/1558 "2024-01-09T14:05:12Z")\
**Posts on this page:** 1\
**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 9, 2024, 2:05pm UTC](https://discourse.greatexpectations.io/t/great-expectation-data-assistant-missingness-unable-to-fetch-results/1558/1 "2024-01-09T14:05:12Z")

</div>

Hi,

We are unable to fetch results using Data Assistant. Could you please let us know how can we view expectations suggested by the data assistant.  
Please find the below sample code.

import great\_expectations as gx

context = gx.get\_context()  
my\_connection\_string = f"snowflake://{sfUser}:{sfPassword}@{ACCOUNT\_NAME\_OR\_LOCATOR}/{sfDatabase}/{sfSchema}?warehouse={sfWarehouse}&role={sfROLE}"  
datasource\_name = “my\_snowflake\_datasource”  
datasource = context.sources.add\_snowflake(  
name=datasource\_name,  
connection\_string=my\_connection\_string,  
)  
asset\_name = “my\_query\_asset”  
query = “select \* from bdaas\_conformed.loan\_monthly\_cnfrmd where p\_process\_date\_n = 20231121”  
query\_asset = datasource.add\_query\_asset(name=asset\_name, query=query)  
data\_asset = context.get\_datasource(datasource\_name).get\_asset(asset\_name)  
batch\_request = data\_asset.build\_batch\_request()  
expectation\_suite\_name = “dry\_run\_7”

validator = context.get\_validator(  
datasource\_name=datasource\_name,  
data\_asset\_name=data\_asset,  
batch\_request=batch\_request  
)

data\_assistant\_result = context.assistants.missingness.run(  
validator=validator,  
estimation=“flag\_outliers”  
)

validator.expectation\_suite = data\_assistant\_result.get\_expectation\_suite(  
expectation\_suite\_name=expectation\_suite\_name  
)

validator.save\_expectation\_suite(discard\_failed\_expectations=False  
)
