SQL Commands Reference

Dremio provides comprehensive SQL access to your data, no matter where it is stored.

• ALTER FOLDER
• ALTER Reflections
• ALTER PIPE
• ALTER SPACE
• ALTER SOURCE
• ALTER TABLE
• ANALYZE TABLE
• CREATE, ALTER, DROP Datasets
• CREATE TABLE
• CREATE TABLE AS
• CREATE PIPE
• CREATE, ALTER, DROP Users
• DESCRIBE PIPE
• DROP PIPE
• DROP TABLE
• GRANT/REVOKE Privileges
• CREATE, ALTER, UNSET, DROP Row-Access & Column-Masking (Dremio 22.0+)
• SELECT
• SHOW TBLPROPERTIES
• SHOW, CREATE, DESCRIBE, DROP User-Defined Functions (Dremio 22.0+)
• USE
• WITH