The autocomplete feature can be enabled or disabled for all users under Settings > SQL.

Suggestions depend on the current context. Autocomplete can provide suggestions for SQL keywords, catalog objects, and functions while you are constructing SQL statements. When enabled, autocomplete lets you view and insert possible completions in the editor using the mouse or the arrow keys with Tab or Enter. For more information, see Azure Data Explorer.Īutocomplete is now available in the SQL Editor. You can now add Azure Data Explorer (ADX) as a database source in Dremio. See SQL Commands for Apache Iceberg Tables for more information. This release adds to existing Iceberg DML capabilities allows users to run DELETE, UPDATE, MERGE, and TRUNCATE statements against Iceberg tables. This allows administrators to dynamically exclude or mask private data at the column and row levels prior to query execution and without physically altering the original values. UDFs let you extend the capabilities of Dremio SQL, provide a layer of abstraction to simplify query construction, encapsulate business logic, and support row and column policies for access control.ĭremio now supports row-access and column-masking policies for row and column controls over user query access to sensitive tables, views, and columns. This release adds support for SQL scalar user-defined functions (UDFs), which are callable routines that make it easier for you to write and reuse SQL logic across queries.

Free instal DataExplorer 3.8.0