General settings

• System timezone – timezone used by the application

• Server URL – URL that is displayed in HTML reports and alerts

• Session max inactive interval (minutes) – Max inactivity period after which user will be logged out

• Session max length (minutes) – Max session length for active user after which user will be logged out

• Connection status update interval (minutes) – interval of connection check for added connections

• Logo – Whitelabel logo to be displayed in top left corner (png, jpg supported)

• Enable file scanning – if this is enabled, then all uploaded files will be scanned with external clamAV client

  • File scan url - ClamAV service URL with port

• Enable DNS whitelisting – if this is enabled, then all external connections will be validated against DNS whitelist

  • DNS whitelist values - Comma separated list of DNS values to whitelist. Can be full DNS or just root DNS

• Enable directory whitelisting – if this is enabled, then all directory access will be validated against directory whitelist

  • DNS whitelist values - Comma separated list of directory values to whitelist. Must be absolute path

• Enable temporary user access – Allows unauthenticated visitors to access DQM as temporary read-only users via a shareable link

  • Temporary user access role – Reader role assigned to temporary users (only reader roles are available). This determines what pages and data temporary users can view

  • Max temporary users – Maximum number of concurrent temporary users allowed. New temporary users will be rejected when this limit is reached

  When enabled, a "Continue as temporary user" button appears on the login page. The direct link /login/anonymous can also be shared - visitors will be automatically logged in as a temporary user after a brief confirmation screen.

  Temporary users are assigned a randomly generated username and the configured reader role. They can only view data and are automatically deleted when their session expires or on logout. See Temporary users for more details.

• Parallel scheduled execution – Maximum number of scheduled executions in parallel (recommended 2)

• Compare rows limit – maximum amount of database rows to be queried in compare test cases. This limit can be set to manage memory performance

• Top N column values profiled – count of values that can be profiled for columns

• Exclude tests with status ‘error’ when sending alerts – Test cases with database error results are excluded when calculating test suite results to send alerts

• HTML attachment in emails – Full HTML reports will be included within the email

• HTML test suite report row limit in email content – Maximum number of detailed test rows included in email content (recommended 100)

• Test case query result row limit – number of test case failed results saved into CSV file (recommended 1000)

• Test suite HTML report results row limit – sample results displayed for a failed test case in test suite HTMLreport (recommended 10)

• CSV file history (days) – Test case CSV result files kept in local file system (recommended 29)

• Test execution history (days) – Test case execution history data retention in days (recommended 60)

• Test execution history (count) – Test case execution history data retention in count of executions (recommended 120)

• Profiling execution history (count) – Profiling execution history data retention in count of executions (recommended 60)

• Test suite report file history (days) – Test suite report HTML files kept in local file system (recommended 29)

• Enable entity auditing – Enable diff based auditing for supported entities

• Audit entity history (days) – Entity audit history version retention in days (recommended 30)

• Audit entity history (count) – Entity audit history version retention in count of versions (recommended 15)

• Enable AI assistant – Whether AI assistant will be accessible.

• API type - OpenAI, Ollama, or Azure OpenAI.

• API endpoint – AI assistant API endpoint. Local models are supported as well if you have them made available via an API. Example endpoint configurations (can vary depending on how your IT department makes the services accessible):

  • OpenAI - https://api.openai.com/v1

  • Ollama - https://your-ollama-host:11434

  • Azure OpenAI - https://xxx.cognitiveservices.azure.com

• Model name – Name of the model that is available through the API endpoint. The model has to support structured outputs via json mode. For local models, it is not suggested to use models below 7B params, the more the better.

• Authentication type – API authentication type, api key or none.

• Authentication token – Api key value.

• Include profiling values - Include profiling values of columns in the prompts.

• Request character limit – Requests containing more characters over this limit won't be sent to the model. Selected table context counts towards that limit.

• Test saved configuration - Tests the connection using currently saved configuration and a test prompt.

Module toggles enable optional integrations. Changes here require an application restart to take full effect.

• Enable dbt – exposes the dbt integration tab and dbt-related features. See dbt setup.

• Enable MCP – exposes the SelectZero MCP server and catalog tools.

• Enable AI assistant tools over MCP – exposes AI assistant test-case suggestions through MCP. Requires the AI assistant to be configured. Only shown when Enable MCP is on.

• Max PAT lifetime – caps the choices available in the personal access token creation dialog (1, 7, 14, or 30 days). Admins can override this when issuing their own PATs and select up to 1 year or no expiry. Only shown when Enable MCP is on.