---
title: "Sample Attributes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/dummy/attributes
original: https://documentation.invantive.eu/en/datamodels/dummy/attributes
updated: 2026-11-01T16:09:06Z
license: https://documentation.invantive.eu/en/
---

# Sample Attributes

## Behaviour

### dummy-data-writable

Whether a replica table whose file does not say otherwise accepts changes, which are kept in memory and lost when the connection is opened again.

- Set from: connection string, provider file
- Defined by: {res:itgen_sample}

### dummy-rebase

Which replica tables have their dates moved to today when read: empty or 1 for all, 0 for none, or table names separated by commas.

- Set from: connection string, set statement, provider file
- Defined by: {res:itgen_sample}

### force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### forced-casing-identifiers

Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### group-by-pushdown-max-groups

Maximum number of groups a data container may answer to a pushed group by before the rows are read instead. Zero switches the push off.

- Default: `1000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-compress-sparse-arrays

Whether to compress sparse arrays in result sets during compression.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-correct-invalid-date

Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-child-exists-filters-to-data-containers

A filter on the existence of a related row is evaluated by the data container where reasonably possible, so that rows are left out before they are transferred.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-projections-to-data-containers

Only the columns a statement actually uses are requested from the data container where reasonably possible, which reduces the volume transferred.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-forward-projections-to-synchronize-target

The table a synchronize writes is read for the columns it compares only, which are the columns present on both sides, instead of for all of them.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-share-byte-arrays

Whether to share the memory used by identical byte arrays in result sets during compression.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-share-strings

Whether to share the memory used by identical strings in result sets during compression.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### max-length-identifiers

Non-default maximum length in characters of identifier names.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### partition-slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a partition-based rate limit.

- Default: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### partition-slot-based-rate-limit-slots

Number of slots per partition-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### pre-request-delay-ms

Pre-request delay in milliseconds per request.

- Default: `0`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### requested-maximum-usable-partitions

Requested Maximum Usable Partitions

- Set from: connection string, set statement, provider file
- Defined by: Shared

### slot-based-rate-limit-length-ms

Total length in milliseconds across all slots of a slot-based rate limit.

- Default: `60000`
- Set from: connection string, provider file
- Defined by: Shared

### slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit.

- Set from: connection string, provider file
- Defined by: Shared

### standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: Shared

## Caching

### invantive-use-cache

Whether to cache the results of a query.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

## Connection

### dummy-data-folders

Folders with the replica tables of this connection as text files, separated by a semicolon, where a table in a later folder replaces one of the same name in an earlier folder.

- Set from: connection string, provider file
- Defined by: {res:itgen_sample}

### dummy-reference-folders

Folders holding the reference test sets of the catalog Reference with one subfolder per schema, separated by a semicolon, or by a comma in a connection string.

- Set from: connection string, provider file
- Defined by: {res:itgen_sample}

## Diagnostics

### analysis-enforce-row-uniqueness

Enforce rows to be unique for software analysis. A fingerprint is calculated from the whole row of data when the primary key column is unknown.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### dummy-partition-count

Number of partitions this connection has. Left empty it has four of which one may be selected at a time. Set, the default four are still there and the rest are generated behind them, and more than one may be selected at once, so that a statement reads them in parallel.

- Set from: connection string, set statement, provider file
- Defined by: {res:itgen_sample}

### dummy-refuse-every-nth-call

Refuse every so many calls, the way a platform does when it is asked too much. The refusal is waited out and the call is made again, so the statement still completes;
 what changes is that the waiting is counted as a refusal. Left empty no call is refused.

- Set from: connection string, set statement, provider file
- Defined by: {res:itgen_sample}

### invantive-sql-execution-profile-disk-file-name

Name of the file to write the execution profile of statements to.

- Default: `profile-{date}-{applicationname}-{currentprocessid}-{sessionid}.ndjson`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-execution-profile-disk-path

Folder to write the execution profile of statements to.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### invantive-sql-execution-profile-to-disk

Whether to write the execution profile of statements to disk.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### log-native-calls-to-disk-max-events

Maximum number of call events to register from last activation.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-max-sec

Maximum number of seconds to register calls from last activation.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-on-error

Registers native calls to data container backend as disk files when the call raised an error.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-disk-on-success

Registers native calls to data container backend as disk files when the call raised no error.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### log-native-calls-to-trace

Log native calls to data container backend on the trace.

- Default: `False`
- Set from: connection string, set statement, provider file
- Defined by: Shared

## Performance

### bulk-delete-page-size-rows

Number of rows to delete per batch when bulk deleting.

- Default: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-bytes

Approximate maximum size in bytes of batch when bulk inserting.

- Default: `10000000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### bulk-insert-page-size-rows

Number of rows to insert per batch when bulk inserting.

- Default: `10000`
- Set from: connection string, set statement, provider file
- Defined by: Shared

### invantive-sql-psql-max-parallel

Maximum degree of the PSQL parallel constructs: session default and cap for every parallel statement or loop without an explicit degree. The value 1 runs every parallel construct sequentially with unchanged semantics.

- Default: `48`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading

Whether data which the session is expected to ask for shortly may be fetched while the session is idle. What that may cost is governed by the settings below, and it stops the moment the session asks for something itself.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-blobs-per-minute

Number of file contents, such as document attachments, which may be fetched ahead per minute. Most platforms do not count these against their request rate, so they pace themselves.

- Default: `20`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-daily-reserve-fraction

Part of the daily allowance of a platform which is never spent on fetching ahead, so that a session keeps room for the rest of its day.

- Default: `0,4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-disk-budget-mb

Number of megabytes which fetching ahead may write to the local caches of this user.

- Default: `8192`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-first-use-rows

Number of rows fetched of each table in a session for which no history of earlier questions is available. A first look at a table shows a few hundred rows, and having those ready is what makes it feel instant.

- Default: `1000`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-horizon-min

Number of minutes ahead over which the expectation of a table being asked for is weighed.

- Default: `60`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-idle-scope-data-container

Whether only the traffic of the same data container counts as the session being busy, rather than all traffic of the session. Suits a script, which is nearly always busy on one platform while its next step reads another.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-idle-sec

Number of seconds a session must have been idle before data is fetched ahead, and before fetching resumes after the session asked for something.

- Default: `5`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-journal

Whether the history of earlier questions of this user is used to decide what to fetch ahead. Switched off, only what the drivers propose and what is announced is used.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-linger-sec

Number of seconds a host keeps a session after its user has left, for as long as fetching ahead has work which the allowances permit.

- Default: `900`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-max-parallel

Number of tables which may be fetched ahead at the same time on one connection.

- Default: `4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-max-unattended-sec

Number of seconds without any question from the session after which fetching ahead stops until the session asks something again.

- Default: `7200`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-node-max-parallel

Number of tables which may be fetched ahead at the same time by this installation, over all the sessions it serves.

- Default: `4`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-partitions

Codes of the partitions, separated by commas, on which fetching ahead may work. Left empty, it works on every partition the session has selected.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-rate-fraction

Part of the minutely request rate of a platform, per partition, which may be spent on fetching ahead. The remainder stays free for what the session asks itself.

- Default: `0,75`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-serve-stale-max-age-sec

Age in seconds up to which a question about a table which is held locally is answered from what is held, without asking the platform for the changes since. The local copy is brought up to date behind the answer, so the next question sees them. Empty, which is the default, always asks.

- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-superset

Whether a question with a filter may be answered from a table which this session already fetched whole, instead of asking the platform to apply the filter.

- Default: `True`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### preemptive-loading-superset-max-rows

Number of rows up to which a question with a filter is answered from a set which this session already fetched whole, instead of asking the platform to apply the filter. Above it the platform is asked, since walking a large set locally costs more than a call which returns a fraction of it.

- Default: `250000`
- Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1

### requested-page-size

Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.

- Set from: connection string, set statement, provider file
- Defined by: Shared

### requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

- Default: `32`
- Set from: connection string, set statement, provider file
- Defined by: Shared



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Dummy](/en/release-notes/drivers?driver=dummy)

