# Can a single expectation suite contain multiple tables with different expectations for different tables

**URL:** <https://discourse.greatexpectations.io/t/can-a-single-expectation-suite-contain-multiple-tables-with-different-expectations-for-different-tables/1301>\
**Category:** GX Core Support\
**Tags:** airflow, s3\
**Created:** [July 26, 2023, 10:00am UTC](https://discourse.greatexpectations.io/t/can-a-single-expectation-suite-contain-multiple-tables-with-different-expectations-for-different-tables/1301 "2023-07-26T10:00:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![lionel](https://avatars.discourse-cdn.com/v4/letter/l/f9ae1b/32.png) [@lionel](https://discourse.greatexpectations.io/u/lionel)\
**Post date:** [July 26, 2023, 10:00am UTC](https://discourse.greatexpectations.io/t/can-a-single-expectation-suite-contain-multiple-tables-with-different-expectations-for-different-tables/1301/1 "2023-07-26T10:00:01Z")

</div>

I want to run GE against snowflake tables in a DB can i have one suite that specifies a expectation for a particular table.  
thanks

---

<div class="post-metadata">

**Author:** ![HaebichanGX](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/haebichangx/32/211_2.png) [@HaebichanGX](https://discourse.greatexpectations.io/u/HaebichanGX)\
**Post date:** [July 26, 2023, 2:59pm UTC](https://discourse.greatexpectations.io/t/can-a-single-expectation-suite-contain-multiple-tables-with-different-expectations-for-different-tables/1301/2 "2023-07-26T14:59:07Z")

</div>

Hi @lionel great to have you on Discourse. So the short answer is no. If you have multiple independent tables with their own independent expectations, you can’t have one expectation suite facilitate that relationship. You would need one expectation suite per expectation and pair that suite with your table loaded in an individual batch request. You can do this under a validations list:

```auto
validations = [
    {"batch_request": table1_br, "expectation_suite_name": "es1"},
  {"batch_request": table2_br, "expectation_suite_name": "es2"},
...
 ]

```

If you want to apply multiple expectations for one table loaded in a batch request, this is possible through the following code:

```auto
from great_expectations.core.expectation_configuration import ExpectationConfiguration

ec = ExpectationConfiguration(
    expectation_type="expect_column_values_to_not_be_null",
    kwargs={"column": "passenger_count"},
)

ec2 = ExpectationConfiguration(
    expectation_type="expect_column_values_to_be_null",
    kwargs={"column": "Name"},
)

suite = context.add_expectation_suite(
    expectation_suite_name="example_suite", expectations=[ec,ec2]
)

```