Project Preferences

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

To view the available preferences:

1. In the Dremio console, hover over in the side navigation bar and select Project settings.

2. Select Preferences in the project 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.	If you would rather click directly on a dataset to see or edit the definition, disable this preference. 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.
Autonomous Reflections	Enabled	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 in Explore with 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 Wikis and Labels.