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