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 the Project Settings icon 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 button 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.

Setting	Default	Enabled	Disabled	Details
SQL Autocomplete	Enabled	Autocomplete provides suggestions for SQL keywords, catalog objects, and functions while you are constructing SQL statements. The Autocomplete button 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 Results	Enabled	The Copy button and **Download** button 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 Click	Disabled	Clicking on a dataset opens the SQL Runner with a default SELECT statement on the dataset. This also changes the edit options that appear when hovering over the dataset on the Datasets page.	Clicking on a dataset opens the Datasets page, allowing users to edit the definition of the dataset.	See how this works in Querying a Dataset on Click.
Generative AI Capabilities	Disabled	Allows Generative AI functionality across the Sonar project, making Text-to-SQL visible in the SQL editor toolbar. Please note that these capabilities may occasionally generate incorrect information, produce harmful instructions or biased content, and have limited world knowledge. This feature set is experimental and not currently GDPR compliant.	The Text-to-SQL button is hidden from the SQL editor toolbar and the side panel for Generative AI is not available.	See how this works in Text-to-SQL.

Querying a Dataset on Click

When this setting is enabled, the Dremio console behaves as follows:

1. Clicking on a dataset opens the SQL Runner with a default SELECT statement on the dataset, as shown in this image:

   

2. When hovering over the dataset on the Datasets page, you can click on the edit option that appears, which depends on whether the dataset is a view or a table.

   a. For views, there is an Edit button to view or edit the DDL (or original SQL) statement that was used for the dataset. The SQL editor will pre-populate the DDL statement as long as you have privilege access for the dataset.

   b. For tables, there is a Go to Table button to view the metadata and edit the definition of the dataset, because tables cannot be modified. If you want to edit the table, you will need to save it as a view.

   If you are viewing a table or you don’t have privilege access for the dataset, the default SELECT * FROM <dataset> statement will be pre-populated in the SQL editor on the Data tab, as shown in this image:

   

   Location	Description
   1	The title displays the name of the open dataset.
   2	The Data panel is used to explore your data catalog.
   3	Collapsing the Data panel hides the panel from view.
   4	The Data tab on the Datasets page opens the SQL editor.
   5	Because this is a table, the default SELECT statement is pre-populated in the SQL editor.
   6	Options for saving your SQL statement are in the top-right corner of the SQL editor.

note

When querying or editing a dataset, a preview of the results will not render by default. The results will only load if you explicitly click Run or Preview.