Preferences

Overview

This guide provides instructions on how to configure the user environment settings in QueryPie.

My Account

In the My Account tab, you can view your account information and change your password.

The password change feature is only supported for accounts created within QueryPie. For SSO Login, please use the individual IdP’s user settings to change your password.

Approval Settings

In the Approval Settings tab, you can set up delegate approval.

For detailed instructions on using the delegate approval feature, please refer to the Approval Add-ons document.

1. Delegate Approval to: Enter the approver for delegation (only one user can be selected).

2. Start Date: Enter the start date for approval delegation.

3. End Date: Enter the end date for approval delegation.

4. Delegation Reason: Enter the reason for setting up delegated approval (optional).

Editor

In the Editor tab, you can configure the appearance and functionality of the SQL editor.

• Theme: Choose between Light or Dark theme.

• Editor: Configure the following settings:

  • Font Size: Specify the font size.

  • Tab Size: Set the tab indentation width.

  • Auto Complete: Enable or disable auto-completion for key queries.

  • Automatic Line Change: Enable or disable word wrap.

  • Full Scan Warning: Enable or disable warnings for queries that may include a full DB scan.

• Grid: Configure grid settings (applied to all table-formatted displays):

  • Font Size: Specify the font size.

  • Row Height: Set the row height (em).

    • Example: 2 em = {Font Size} * 2

  • How to Show NULL Item: Specify how to display cells with no value (default: NULL).

Shortcut

In the Shortcut tab, you can view and modify the shortcuts applied to the SQL Editor.

Configuration

In the Configuration tab, you can manage Kerberos keytabs. Click Create Keytab to upload a keytab file.

QueryPie Lab

The QueryPie Lab tab offers experimental features, including the high-performance web terminal as of version 10.0.0.

Note: Experimental features may be less stable and could be removed in future updates.

• Use High Performance Web Terminal: This feature is optimized for high-memory performance tasks, such as using multiple sessions simultaneously or exploring large log files.