# How to add all batch partitions to checkpoint

**URL:** <https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668>\
**Category:** Archive\
**Created:** [March 17, 2021, 4:48pm UTC](https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668 "2021-03-17T16:48:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![hansen.peterd](https://avatars.discourse-cdn.com/v4/letter/h/48db29/32.png) [@hansen.peterd](https://discourse.greatexpectations.io/u/hansen.peterd)\
**Post date:** [March 17, 2021, 4:48pm UTC](https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668/1 "2021-03-17T16:48:50Z")

</div>

I am wondering how to simply add all the partitions specified by the datasource to the checkpoint.  
it seems odd to copy and paste the batch definition over and over, changing the index.

Checkpoint yml

```
name: carriers
config_version: 1
class_name: SimpleCheckpoint
validations:
  - batch_request:
      datasource_name: db
      data_connector_name: random
      data_asset_name: Carrier_THG_20200324
      partition_request:
         partition_identifiers:
            RandomId: 0

    expectation_suite_name: carrier

```

config datasources yml

```
datasources:
  db:
    module_name: great_expectations.datasource
    connection_string: mssql+pyodbc://SERVER/DATABASE?driver=ODBC+Driver+17+for+SQL+Server&charset=utf&autocommit=true&Trusted_Connection=yes
    tables:
      TABLENAME:
        partitioners:
          random:
            splitter_method: _split_on_mod_integer
            splitter_kwargs:
              column_name: RandomId
              mod: 7
    class_name: SimpleSqlalchemyDatasource

```

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [March 22, 2021, 4:40pm UTC](https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668/2 "2021-03-22T16:40:21Z")

</div>

@hansen.peterd This is a great idea to have a fast way to configure “all partitions”. Could you please copy this into a GitHub issue so that we can track it as a feature request? Thank you!

---

<div class="post-metadata">

**Author:** ![hansen.peterd](https://avatars.discourse-cdn.com/v4/letter/h/48db29/32.png) [@hansen.peterd](https://discourse.greatexpectations.io/u/hansen.peterd)\
**Post date:** [March 23, 2021, 9:43pm UTC](https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668/3 "2021-03-23T21:43:33Z")

</div>

Here is the issue

> <https://github.com/great-expectations/great_expectations/issues/2578>
>
> If I define a data source using partitions, e.g.
> db:
> module\_name: great\_expectations.datasource
> connection\_string: mssql+pyodbc://SERVER/DATABASE?driver=ODBC+Driver+17+for+SQL+Server&charset=utf&autocommit=true&Trusted\_Connection=yes
> tables:
> TABLENAME:
> partitioners:
> random:
> splitter\_method: \_split\_on\_mod\_integer
> splitter\_kwargs:
> ...

---

<div class="post-metadata">

**Author:** ![eugene.mandel](https://yyz1.discourse-cdn.com/flex031/user_avatar/discourse.greatexpectations.io/eugene.mandel/32/22_2.png) [@eugene.mandel](https://discourse.greatexpectations.io/u/eugene.mandel)\
**Post date:** [March 26, 2021, 2:20pm UTC](https://discourse.greatexpectations.io/t/how-to-add-all-batch-partitions-to-checkpoint/668/4 "2021-03-26T14:20:26Z")

</div>

Prefect - thank you for filing it!