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
)