Skip to main content

​
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

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 Snowflake 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 Snowflake schema does not match the internal Atoti schema.
directquery.database
directquery.database.typesnowflakeThis ensures the application configures the appropriate connection for a Databricks database.
directquery.snowflake
directquery.snowflake.connection-stringSNOWFLAKECONNECTIONSTRING</code></td><td>TheconnectionstringforyourSnowflakeaccount,providedasanenvironmentvariable.</td></tr><tr><td>directquery.snowflake.username</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}The username for an account that will be used to connect to Snowflake, provided as an environment variable.
directquery.snowflake.passwordSNOWFLAKEPASSWORD</code></td><td>ThepasswordforanaccountthatwillbeusedtoconnecttoSnowflake,providedasanenvironmentvariable.</td></tr><tr><td>directquery.snowflake.warehouse</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}The Snowflake warehouse that will be used to run queries, provided as an environment variable.
directquery.snowflake.feeding-warehouseSNOWFLAKEWH</code></td><td>Anoptionalsecondarywarehouseusedforhigh−volumequeriesrunatapplicationstartup,providedasanenvironmentvariable.</td></tr><tr><td>directquery.snowflake.database</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}The Snowflake database containing your data, provided as an environment variable.
directquery.snowflake.schemaSNOWFLAKESCHEMA</code></td><td>TheSnowflakeschemacontainingyourdata,providedasanenvironmentvariable.</td></tr><tr><td>directquery.snowflake.role</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}The Snowflake role used to access your data, provided as an environment variable.