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.

Setting	Default	Enabled	Disabled	Details
SQL Autocomplete	Enabled	Autocomplete 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 Results	Enabled	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 Click	Enabled	Clicking 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.
Autonomous Reflections	Disabled	Dremio automatically creates and drops Reflections based on query patterns from the last 7 days to seamlessly accelerate performance.	Dremio will provide recommendations to create and drop Reflections based on query patterns from the last 7 days to accelerate query performance.	See how this works in the Autonomous Reflections.
AI Features	Enabled	When enabled, users can interact with the Dremio's AI Agent and AI functions. The AI Agent enables agentic workflows, allowing analysts to work with the agent to generate SQL queries, find insights, and create visualizations. The AI functions allow engineers to query unstructured data and use LLMs during SQL execution.	The AI Agent and AI functions will not work.	See how this works with the AI Agent and AI Functions.
Generate wikis and labels	Enabled	In the Details panel, both Generate Wiki and Generate Labels links will be visible for generating wikis and labels.	The links for Generate Wiki and Generate Labels will be hidden, making these features unavailable.	See how this works in Generate Wikis and Labels.