> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DirectQuery annotations

This section gives you an overview on how you can use the Spring annotations defined in Atoti Market Risk to simplify the configuration when DirectQuery is used.

## How it works

Some Spring annotations have been defined to make the definition of Beans easier. You can define these annotations at the Bean level or at the Class level.

<table><thead><tr><th>Annotation</th><th>Description</th></tr></thead><tbody><tr><td><code>@ConditionalOnAdjustmentsWithDirectQuery</code></td><td>Annotation used on configuration classes and beans to specify that the read-only adjustments are activated with DirectQuery. Equivalent to <code>@ConditionalOnSignOffEnabled</code> and <code>@ConditionalOnDirectQueryDatabase</code></td></tr><tr><td><code>@ConditionalOnDatabricks</code></td><td>Annotation that can be used to only create a Spring configuration if DirectQuery is set to run with Databricks.</td></tr><tr><td><code>@ConditionalOnDirectQueryCacheDisabled</code></td><td>This annotation is conditional on the <a href="./caching-side-stores">DirectQuery local cache</a> being disabled.</td></tr><tr><td><code>@ConditionalOnDirectQueryCacheEnabled</code></td><td>This annotation is conditional on the <a href="./caching-side-stores">DirectQuery local cache</a> being enabled.</td></tr><tr><td><code>@ConditionalOnDirectQueryDatabase</code></td><td>This annotation is conditional on DirectQuery being enabled.</td></tr><tr><td><code>@ConditionalOnInMemoryDatabase</code></td><td>This annotation is conditional on DirectQuery being disabled, that is, on the in-memory datastore being used.</td></tr><tr><td><code>@ConditionalOnMSSQL</code></td><td>Annotation that can be used to only create a Spring configuration if DirectQuery is set to run with Microsoft SQL Server.</td></tr><tr><td><code>@ConditionalOnNoAdjustmentsWithDirectQuery</code></td><td>Annotation used on configuration classes and beans to specify that the adjustments are deactivated with DirectQuery and Sign-Off compatibility Equivalent to ConditionalOnSignOffEnabled and ConditionalOnDirectQueryDatabase.</td></tr><tr><td><code>@ConditionalOnSignOffDisabled</code></td><td>Annotation used on configuration classes and beans to specify that the adjustments and Sign-Off are disabled.</td></tr><tr><td><code>@ConditionalOnSignOffEnabled</code></td><td>Annotation used on configuration classes and beans to specify that the adjustments and Sign-Off are activated.</td></tr><tr><td><code>@ConditionalOnSignOffHierarchy</code></td><td>Annotation used on configuration classes and beans to specify that the Sign-Off hierarchy has to be displayed whenever the Sign-Off is really working (in the case of DirectQuery).</td></tr><tr><td><code>@ConditionalOnSnowflake</code></td><td>Annotation that can be used to only create a Spring configuration if DirectQuery is set to run with Snowflake.</td></tr></tbody></table>