SQL Commands

• SELECT — structure of SQL queries in Dremio.

• DDL (Data Definition Language) commands are used to create, manipulate, and modify objects in Dremio:

  • Context
  • Reflections
  • Tables (Iceberg and non-Iceberg)
  • Views
  • Privileges
  • Roles
  • Row-Access & Column-Masking
  • User-Defined Functions
  • Users
  • Engine Routing

• DML (Data Manipulation Language) commands are used to manipulate data and, in Dremio, are currently applicable only to Apache Iceberg tables:

  • DELETE
  • INSERT
  • MERGE
  • TRUNCATE
  • UPDATE

• Dremio Arctic (Preview)