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
| 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 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 Databricks database. |
| directquery.snowflake | ||
| directquery.snowflake.connection-string | ${SNOWFLAKE_CONNECTION_STRING} |
The connection string for your Snowflake account, provided as an environment variable. |
| directquery.snowflake.username | ${SNOWFLAKE_USERNAME} |
The username for an account that will be used to connect to Snowflake, provided as an environment variable. |
| directquery.snowflake.password | ${SNOWFLAKE_PASSWORD} |
The password for an account that will be used to connect to Snowflake, provided as an environment variable. |
| directquery.snowflake.warehouse | ${SNOWFLAKE_WH} |
The Snowflake warehouse that will be used to run queries, provided as an environment variable. |
| directquery.snowflake.feeding-warehouse | ${SNOWFLAKE_WH} |
An optional secondary warehouse used for high-volume queries run at application startup, provided as an environment variable. |
| directquery.snowflake.database | ${SNOWFLAKE_DB} |
The Snowflake database containing your data, provided as an environment variable. |
| directquery.snowflake.schema | ${SNOWFLAKE_SCHEMA} |
The Snowflake schema containing your data, provided as an environment variable. |
| directquery.snowflake.role | ${SNOWFLAKE_ROLE} |
The Snowflake role used to access your data, provided as an environment variable. |