Skip to main content

Dremio Preferences

Preferences let you customize the behavior of specific features in the Dremio console.

Managing Preferences​

To view the available preferences in the Dremio console:

  1. Click in the side navigation bar.

  2. Select Preferences in the settings sidebar.

    This opens the Preferences page, showing the Dremio console settings that can be modified.

  3. Use the toggle next to the setting to enable or disable for all users.

    If any preferences are modified, users must refresh their browsers to see the change.

These preferences and their descriptions are listed in the table below.

SettingDefaultEnabledDisabledDetails
SQL AutocompleteEnabledAutocomplete provides suggestions for SQL keywords, catalog objects, and functions while you are constructing SQL statements. is visible in the SQL editor, although users can switch the button off within their own accounts.The button is hidden from the SQL editor and suggestions are not provided.See how this works in the SQL editor.
Copy or Download ResultsEnabled and are visible above the results table, because users are allowed to copy or download the results in the SQL editor.The buttons are hidden and users cannot copy or download results in the SQL editor.See how this works in result set actions.
Query Dataset on ClickEnabledClicking on a dataset opens the SQL Runner with a SELECT statement on the dataset.Clicking on a dataset opens the Datasets page, showing a SELECT statement on the dataset or the dataset's definition that you can view or edit depending on your dataset privileges.See how this works in Querying a Dataset on Click.
Generative AIDisabledAllows Generative AI functionality across the Sonar project. This is the icon that represents Generative AI. is visible in the SQL editor toolbar for Text-to-SQL and in the Dataset Overview for generating labels. In the Wiki section, a Generate wiki link is visible for generating wikis. Note that these features have limited world knowledge and may occasionally generate incorrect information, harmful instructions, or biased content. For more information, see Data Privacy.Generative AI features are unavailable. The button is hidden from the SQL editor toolbar for Text-to-SQL and from the Dataset Overview for generating labels. Also, the link to generate a wiki is hidden.See how this works in Generative AI.