SQL Templates
Stores SQL templates and variables used during generated SQL execution.
Use this page to find the SQL Templates settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| Main DWH SQLCMD Variable | MAIN_DWH_SQLCMD_VARIABLE | $ | SQLCMD variable used to address the main DWH database. Will be used in case of multi-DB DWH. |
| Update Statistics Hist Template | UPDATE_STATISTICS_HIST_TEMPLATE | UPDATE STATISTICS {TableName} | Pattern to create UPDATE STATISTICS statement in historizing stored procedure. {TableName} can be used as an alias. |
| Update Statistics Persist Template | UPDATE_STATISTICS_PERSIST_TEMPLATE | UPDATE STATISTICS {TableName} | Pattern to create UPDATE STATISTICS statement in persisting stored procedure. {TableName} can be used as an alias. |
