> ## 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

export const productName = "Atoti FRTB";

This section gives you an overview on how you can use the Spring annotations defined in {productName} 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 use these annotations at the Bean level or at the Class level.

| Annotation                          | Description                                                                                                                                                                                                                           |
| ----------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `@ConditionalOnInMemoryDatabase`    | This annotation is conditional on DirectQuery being disabled, that is, on the in-memory datastore being used. Underlying Spring property condition:<br />- `starter.deployment.type=in-memory`                                        |
| `@ConditionalOnDirectQueryDatabase` | This annotation is conditional on DirectQuery being enabled. Underlying Spring property condition:<br />- `starter.deployment.type=direct-query`                                                                                      |
| `@ConditionalOnSnowflake`           | This annotation is conditional on DirectQuery being enabled and configured to use a Snowflake Database. Underlying Spring property condition:<br />- `starter.deployment.type=direct-query and directquery.database.type=snowflake`   |
| `@ConditionalOnClickhouse`          | This annotation is conditional on DirectQuery being enabled and configured to use a ClickHouse Database. Underlying Spring property condition:<br />- `starter.deployment.type=direct-query and directquery.database.type=clickhouse` |
| `@ConditionalOnMSSQL`               | This annotation is conditional on DirectQuery being enabled and configured to use a Microsoft SQL Database. Underlying Spring property condition:<br />- `starter.deployment.type=direct-query and directquery.database.type=mssql`   |
| `@ConditionalOnDatabricks`          | This annotation is conditional on DirectQuery being enabled and configured to use a Databricks Database. Underlying Spring property condition:<br />- `starter.deployment.type=direct-query and directquery.database.type=databricks` |