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

## File purpose

This profile is used to run Atoti Market Risk in DirectQuery mode, connecting to a Snowflake 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 Snowflake 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 Snowflake 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>snowflake</code></td><td>This ensures the application configures the appropriate connection for a Databricks database.</td></tr><tr><td>directquery.snowflake</td><td /><td /></tr><tr><td>directquery.snowflake.connection-string</td><td><code>${SNOWFLAKE_CONNECTION_STRING}</code></td><td>The connection string for your Snowflake account, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.username</td><td><code>$\{SNOWFLAKE\_USERNAME}</code></td><td>The username for an account that will be used to connect to Snowflake, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.password</td><td><code>${SNOWFLAKE_PASSWORD}</code></td><td>The password for an account that will be used to connect to Snowflake, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.warehouse</td><td><code>$\{SNOWFLAKE\_WH}</code></td><td>The Snowflake warehouse that will be used to run queries, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.feeding-warehouse</td><td><code>${SNOWFLAKE_WH}</code></td><td>An optional secondary warehouse used for high-volume queries run at application startup, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.database</td><td><code>$\{SNOWFLAKE\_DB}</code></td><td>The Snowflake database containing your data, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.schema</td><td><code>${SNOWFLAKE_SCHEMA}</code></td><td>The Snowflake schema containing your data, provided as an environment variable.</td></tr><tr><td>directquery.snowflake.role</td><td><code>$\{SNOWFLAKE\_ROLE}</code></td><td>The Snowflake role used to access your data, provided as an environment variable.</td></tr></tbody></table>