application-snowflake.yaml - Atoti Hub

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

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; TradeSensitivities: 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 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-schema	`true`	This ensures the application fails to start if the Snowflake schema does not match the internal Atoti schema.
directquery.database
directquery.database.type	`snowflake`	This ensures the application configures the appropriate connection for a Snowflake database.
directquery.database.snowflake
directquery.database.snowflake.connection-string	`${SNOWFLAKE_CONNECTION_STRING}`	The connection string for your Snowflake account, provided as an environment variable.
directquery.database.snowflake.username	`${SNOWFLAKE_USERNAME}`	The username for an account that will be used to connect to Snowflake, provided as an environment variable.
directquery.database.snowflake.warehouse	`${SNOWFLAKE_WH}`	The Snowflake warehouse that will be used to run queries, provided as an environment variable.
directquery.database.snowflake.feeding-warehouse	`${SNOWFLAKE_WH}`	An optional secondary warehouse used for high-volume queries run at application startup, provided as an environment variable.
directquery.database.snowflake.database	`${SNOWFLAKE_DB}`	The Snowflake database containing your data, provided as an environment variable.
directquery.database.snowflake.schema	`${SNOWFLAKE_SCHEMA}`	The Snowflake schema containing your data, provided as an environment variable.
directquery.database.snowflake.role	`${SNOWFLAKE_ROLE}`	The Snowflake role used to access your data, provided as an environment variable.
directquery.database.snowflake.additional-options
directquery.database.snowflake.additional-options.private-key-base64	`${SNOWFLAKE_PRIVATE_KEY_BASE64}`	The base64-encoded RSA private key used for key-pair authentication, provided as an environment variable.