batch_size

💡Did you know...

Available from dbt v1.9 or with the dbt Cloud "Latest" release track.

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(
    materialized='incremental',
    batch_size='day'
) }}