Preferences let you customize the behavior of specific features in the Dremio console.
To view the available preferences in the Dremio console:
Click the Settings icon in the side navigation bar.
Select Preferences in the settings sidebar.
This opens the Preferences page, showing the Dremio console settings that can be modified.
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.
|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 ||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.|
Querying a Dataset on Click
When this setting is enabled, the Dremio console behaves as follows:
Clicking on a dataset opens the SQL Runner with a default
SELECTstatement on the dataset, as shown in this image:
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 make edits to a table, you will need to save it as a view.
If you are using either edit option and you don't have privilege access for the dataset, the default
SELECT * FROM <dataset>statement will be pre-populated instead on the Datasets page, as shown in this image:
Location Description 1 The Data panel is used to explore your data catalog. 2 Collapsing the Data panel hides the panel from view. 3 The Data tab on the Datasets page opens the SQL editor.note
When querying or editing a dataset, a preview of the results is not rendered by default. The results are only loaded if you explicitly click Run or Preview.