batch_size

Available in the dbt Cloud "Latest" release track and dbt Core v1.9 and higher.

Definition

Thebatch_size config determines how large batches are when running a microbatch. Accepted values are hour, day, month, or year. You can configure batch_size for a model in your dbt_project.yml file, property YAML file, or config block.

Examples

The following examples set day as the batch_size for the user_sessions model.

Example of the batch_size config in the dbt_project.yml file:

dbt_project.yml

models:
  my_project:
    user_sessions:
      +batch_size: day

Example in a properties YAML file:

models/properties.yml

models:
  - name: user_sessions
    config:
      batch_size: day

Example in sql model config block:

models/user_sessions.sql

{{ config(
    lookback='day
) }}