Each Test includes a "Toolbox" section where you can enable two options: Settings & Deploy.
1. Settings
Test Settings are divided into three parts:
A. Execution settings:
(The following example refers to Compare Test type)
- Chunk Size - for Compare Tests, Data Set data is always divided into chunks of the selected size. This setting impacts both running time and performance.
How to define suitable Chunk size?
- If the total number of scanned lines is 1,000,000 => chunk size can be between 200,000 and 300,000.
- If the total number of scanned lines is 5,000,000 => chunk size can be between 400,000 and 500,000.
- We generally do not recommend choosing a chunk size > 500,000 to avoid a chunk size that is too large.
Sample Execution Chunk - same as chunk size but for sample Test run.
Column To Index - if not set => by default the most unique column for the first 1000 rows will be chosen. Can be customized by the end user.
Run Without Full Index - deactivate the chosen in "Column to Index" value and run for all rows in query in all Data Sets.
Priority - default value is 50. Is assigned to each Test execution, executions are returned in ordered by priority ascending list.
Number Of Threads - used for chunk deviation by threads. Can be between 1 to 8.
Number Of Result Missing Keys - how many results it will return in report.
Number Of Results - At Different Values - how many results it will return in report.
Test Execution Timeout - what will be the timeout value of the Test execution if it didn't finish and should be stopped. Overwrites global timeout value.
Test Execution Timeout Type - time parameter (minutes/hours etc.)
B. Log settings:
Related to the Excel report, Log Tables and Test results in quilliup UI.
The checkboxes allow to set the number of rows/results and the statuses when values will be added to Excel report / Log Tables / shown in quilliup UI.
C. Test Results Excel Settings:
Remove Meta Data from Excel - if true => no meta data rows (Test name, ...) will be added to the Excel report.
Add Variables To Excel - if true => execution variable(s) will be added to Excel report (not part of Meta Data).
Add SQL query(s) to Excel - if true => SQL query(s) will be added to exported Excel file.
Keep the result history of the last X Days - will keep Test results for set amount of days. Overrides global value set in History Cleansing.
2. Deploy - allows to deploy this specific Test:
Package Name - By default, it’s the test name combined with the current timestamp, but you can manually change it. Note that the timestamp at the end of the package name is added automatically and cannot be removed.
Environment - Select the environment from the list where the test should be deployed.
For more information regarding the Deploy & Import processes, please refer the following manuals:
Comments
0 comments
Please sign in to leave a comment.