Table:
Suite:

Active Assertion Rules (4)

Add New Assertion Expectation
expect_column_values_to_not_be_null
Target Column: order_id | Params: {"mostly":1}
expect_column_values_to_be_unique
Target Column: order_id | Params: {"mostly":1}
expect_column_values_to_be_between
Target Column: gross_amount | Params: {"min_value":0.01,"max_value":50000}
expect_column_values_to_be_in_set
Target Column: order_status | Params: {"value_set":["PLACED","SHIPPED","DELIVERED","REFUNDED"]}

Export Preview (JSON)

{
  "expectation_suite_name": "fct_orders_dq_suite",
  "meta": {
    "great_expectations_version": "0.18.0",
    "generated_by": "InsightfulSaga Tools"
  },
  "expectations": [
    {
      "expectation_type": "expect_column_values_to_not_be_null",
      "kwargs": {
        "column": "order_id",
        "mostly": 1
      }
    },
    {
      "expectation_type": "expect_column_values_to_be_unique",
      "kwargs": {
        "column": "order_id",
        "mostly": 1
      }
    },
    {
      "expectation_type": "expect_column_values_to_be_between",
      "kwargs": {
        "column": "gross_amount",
        "min_value": 0.01,
        "max_value": 50000
      }
    },
    {
      "expectation_type": "expect_column_values_to_be_in_set",
      "kwargs": {
        "column": "order_status",
        "value_set": [
          "PLACED",
          "SHIPPED",
          "DELIVERED",
          "REFUNDED"
        ]
      }
    }
  ]
}