Skip to main content

​
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

KeyValueDescription
configuration
configuration.sign-off
configuration.sign-off.enabledfalseSign-off is not available to use with DirectQuery applications.
mr
mr.enable
mr.enable.cubes
mr.enable.cubes.var-summaryfalseSummary cubes are not available to use with DirectQuery applications.
mr.enable.cubes.pnl-summaryfalseSummary cubes are not available to use with DirectQuery applications.
mr.enable.cubes.sensi-summaryfalseSummary cubes are not available to use with DirectQuery applications.
starter
starter.deployment
starter.deployment.typedirect-queryThis causes Atoti Market Risk to run in DirectQuery mode with the appropriate components configured to enable this.
directquery
directquery.with-adjustmentsfalseWhether the schema contains adjusted data.
directquery.clustering
directquery.clustering.enabledtrueThis enables DirectQuery to use clustering fields to improve data loading performance.
directquery.clustering.clustering-per-tablePnL: AsOfDate; TradePnLs: AsOfDate; TradeSensitivties: AsOfDateThis enables clustering on the AsOfDate field for all base tables.
directquery.schema
directquery.schema.validation
directquery.schema.validation.validate-on-startuptrueThis 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-schematrueThis ensures the application fails to start if the Databricks schema does not match the internal Atoti schema.
directquery.database
directquery.database.typedatabricksThis ensures the application configures the appropriate connection for a Databricks database.
directquery.databricks
directquery.databricks.connection-stringDATABRICKSJDBCURL</code></td><td>ThisistheJDBCURLforaDatabricksclusterthatwillbeusedtoconnectAtotitoDatabricks,providedasanenvironmentvariable.</td></tr><tr><td>directquery.databricks.password</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}This is an access token for that cluster, provided as an environment variable.
directquery.databricks.databaseDATABRICKSCATALOG</code></td><td>ThisistheDatabrickscatalogcontainingyourdata,providedasanenvironmentvariable.</td></tr><tr><td>directquery.databricks.schema</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}This is the Databricks schema containing your data, provided as an environment variable.
directquery.databricks.time-travel-policydisabledThis disables time travel for Databricks and should be changed if required.