---
title: "Configuration: ETL Options"
description: "Tune RavenDB ETL task configuration with batch size limits, extraction intervals, and memory usage thresholds for data transformations."
url: "https://docs.ravendb.net/6.2/server/configuration/etl-configuration"
version: "6.2"
---

# Configuration: ETL Options

> RavenDB publishes an official agent skill for coding assistants at https://docs.ravendb.net/skills/ravendb/SKILL.md (also installable with `npx skills add ravendb/skills`). The skill describes itself as: "Read this before writing any RavenDB query, client call or /databases/ request. Covers server setup, document modelling, the Node.js, .NET and Python clients, RQL, indexes, vector search and AI agents. Code written from recall tends to run and return the wrong rows, because RQL resembles SQL and the clients take field names as plain strings."

> **Note**
>
> - In this article:
>   - [ETL.ExtractAndTransformTimeoutInSec](#etlextractandtransformtimeoutinsec)
>   - [ETL.MaxBatchSizeInMb](#etlmaxbatchsizeinmb)
>   - [ETL.MaxFallbackTimeInSec](#etlmaxfallbacktimeinsec)
>   - [ETL.MaxNumberOfExtractedDocuments](#etlmaxnumberofextracteddocuments)
>   - [ETL.MaxNumberOfExtractedItems](#etlmaxnumberofextracteditems)
>   - [ETL.OLAP.MaxNumberOfExtractedDocuments](#etlolapmaxnumberofextracteddocuments)
>   - [ETL.Queue.AzureQueueStorage.TimeToLiveInSec](#etlqueueazurequeuestoragetimetoliveinsec)
>   - [ETL.Queue.AzureQueueStorage.VisibilityTimeoutInSec](#etlqueueazurequeuestoragevisibilitytimeoutinsec)
>   - [ETL.Queue.Kafka.InitTransactionsTimeoutInSec](#etlqueuekafkainittransactionstimeoutinsec)
>   - [ETL.Raven.LoadRequestTimeoutInSec](#etlravenloadrequesttimeoutinsec)
>   - [ETL.SQL.CommandTimeoutInSec](#etlsqlcommandtimeoutinsec)

## ETL.ExtractAndTransformTimeoutInSec

Number of seconds after which extraction and transformation will end and loading will start.

- **Type**: `int`
- **Default**: `30`
- **Scope**: Server-wide or per database

## ETL.MaxNumberOfExtractedDocuments

- Max number of extracted documents in an ETL batch.
- If value is not set, or set to null, the number of extracted documents fallbacks to `ETL.MaxNumberOfExtractedItems` value.

---

- **Type**: `int`
- **Default**: `8192`
- **Scope**: Server-wide or per database

## ETL.MaxBatchSizeInMb

- Maximum size in megabytes of a batch of data (documents and attachments) that will be sent to the destination as a single batch after transformation.
- If value is not set, or set to null, the size of the batch isn't limited in the processed ETL batch.

---

- **Type**: `Size`
- **Size Unit**: `Megabytes`
- **Default**: `64`
- **Scope**: Server-wide or per database

## ETL.MaxFallbackTimeInSec

- Maximum number of seconds the ETL process will be in a fallback mode after a load connection failure to a destination.
- The fallback mode means suspending the process.

---

- **Type**: `int`
- **Default**: `900`
- **Scope**: Server-wide or per database

## ETL.MaxNumberOfExtractedItems

- Max number of extracted items (documents, counters, etc) in an ETL batch.
- If value is not set, or set to null, the number of extracted items isn't limited in the processed ETL batch.

---

- **Type**: `int`
- **Default**: `8192`
- **Scope**: Server-wide or per database

## ETL.OLAP.MaxNumberOfExtractedDocuments

Max number of extracted documents in OLAP ETL batch.

- **Type**: `int`
- **Default**: `64 * 1024`
- **Scope**: Server-wide or per database

## ETL.Queue.AzureQueueStorage.TimeToLiveInSec

Lifespan of a message in the queue.

- **Type**: `int`
- **Default**: `604800` (7 days)
- **Scope**: Server-wide or per database

## ETL.Queue.AzureQueueStorage.VisibilityTimeoutInSec

How long a message is hidden after being retrieved but not deleted.

- **Type**: `int`
- **Default**: `0`
- **Scope**: Server-wide or per database

## ETL.Queue.Kafka.InitTransactionsTimeoutInSec

Timeout to initialize transactions for the Kafka producer.

- **Type**: `int`
- **Default**: `60`
- **Scope**: Server-wide or per database

## ETL.Raven.LoadRequestTimeoutInSec

- Number of seconds after which the Raven ETL load request will time out.
- Can be overridden per task by setting the `LoadRequestTimeoutInSec` property in the [Raven ETL configuration](https://docs.ravendb.net/6.2/server/ongoing-tasks/etl/raven.md),  
  or via [Studio](https://docs.ravendb.net/6.2/studio/database/tasks/ongoing-tasks/ravendb-etl-task.md#ravendb-etl-task-definition).

---

- **Type**: `int`
- **Default**: `300`
- **Scope**: Server-wide or per database

## ETL.SQL.CommandTimeoutInSec

- Number of seconds after which the SQL command will time out.
- Can be overridden by setting the `CommandTimeout` property in the SQL ETL configuration.

---

- **Type**: `int?`
- **Default**: `null` (use provider default)
- **Scope**: Server-wide or per database
