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

# application-databricks.yaml

## File purpose

This profile is used to run Atoti Market Risk in DirectQuery mode, connecting to a Databricks database.

## File location

The file is located in the folder **mr-application\src\main\resources**.

## File values

<table><thead><tr><th>Key</th><th>Value</th><th>Description</th></tr></thead><tbody><tr><td>configuration</td><td /><td /></tr><tr><td>configuration.sign-off</td><td /><td /></tr><tr><td>configuration.sign-off.enabled</td><td><code>false</code></td><td>Sign-off is not available to use with DirectQuery applications.</td></tr><tr><td>mr</td><td /><td /></tr><tr><td>mr.enable</td><td /><td /></tr><tr><td>mr.enable.cubes</td><td /><td /></tr><tr><td>mr.enable.cubes.var-summary</td><td><code>false</code></td><td>Summary cubes are not available to use with DirectQuery applications.</td></tr><tr><td>mr.enable.cubes.pnl-summary</td><td><code>false</code></td><td>Summary cubes are not available to use with DirectQuery applications.</td></tr><tr><td>mr.enable.cubes.sensi-summary</td><td><code>false</code></td><td>Summary cubes are not available to use with DirectQuery applications.</td></tr><tr><td>starter</td><td /><td /></tr><tr><td>starter.deployment</td><td /><td /></tr><tr><td>starter.deployment.type</td><td><code>direct-query</code></td><td>This causes Atoti Market Risk to run in DirectQuery mode with the appropriate components configured to enable this.</td></tr><tr><td>directquery</td><td /><td /></tr><tr><td>directquery.with-adjustments</td><td><code>false</code></td><td>Whether the schema contains adjusted data.</td></tr><tr><td>directquery.clustering</td><td /><td /></tr><tr><td>directquery.clustering.enabled</td><td><code>true</code></td><td>This enables DirectQuery to use <a href="https://docs.activeviam.com/products/atoti/server/6.1.11/docs/directquery/directquery-clustering-fields/">clustering fields</a> to improve data loading performance.</td></tr><tr><td>directquery.clustering.clustering-per-table</td><td><code>PnL: AsOfDate; TradePnLs: AsOfDate; TradeSensitivties: AsOfDate</code></td><td>This enables clustering on the <code>AsOfDate</code> field for all base tables.</td></tr><tr><td>directquery.schema</td><td /><td /></tr><tr><td>directquery.schema.validation</td><td /><td /></tr><tr><td>directquery.schema.validation.validate-on-startup</td><td><code>true</code></td><td>This ensures the Databricks schema will be validated against the internal Atoti schema at startup with results provided in the logs.</td></tr><tr><td>directquery.schema.validation.fail-startup-on-bad-schema</td><td><code>true</code></td><td>This ensures the application fails to start if the Databricks schema does not match the internal Atoti schema.</td></tr><tr><td>directquery.database</td><td /><td /></tr><tr><td>directquery.database.type</td><td><code>databricks</code></td><td>This ensures the application configures the appropriate connection for a Databricks database.</td></tr><tr><td>directquery.databricks</td><td /><td /></tr><tr><td>directquery.databricks.connection-string</td><td><code>${DATABRICKS_JDBC_URL}</code></td><td>This is the JDBC URL for a Databricks cluster that will be used to connect Atoti to Databricks, provided as an environment variable.</td></tr><tr><td>directquery.databricks.password</td><td><code>$\{DATABRICKS\_PASSWORD}</code></td><td>This is an access token for that cluster, provided as an environment variable.</td></tr><tr><td>directquery.databricks.database</td><td><code>${DATABRICKS_CATALOG}</code></td><td>This is the Databricks catalog containing your data, provided as an environment variable.</td></tr><tr><td>directquery.databricks.schema</td><td><code>$\{DATABRICKS\_SCHEMA}</code></td><td>This is the Databricks schema containing your data, provided as an environment variable.</td></tr><tr><td>directquery.databricks.time-travel-policy</td><td><code>disabled</code></td><td>This disables <a href="https://docs.activeviam.com/products/atoti/server/6.1.11/docs/directquery/databases/databricks/#time-travel-support">time travel for Databricks</a> and should be changed if required.</td></tr></tbody></table>