SQL Commands Reference

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

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