Skip to main content
Version: current [24.2.x]

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 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.

SQL AutocompleteEnabledAutocomplete 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 ResultsEnabledThe 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 ClickDisabledClicking 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.

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:

    This screenshot is displaying the SELECT statement in the SQL Runner.
  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 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:

    This screenshot is displaying the SQL editor within the Datasets page.
    1The Data panel is used to explore your data catalog.
    2Collapsing the Data panel hides the panel from view.
    3The Data tab on the Datasets page opens the SQL editor.

    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.