SQL Reference

• Data Types
• SQL Commands
• SQL Functions
• Reserved Keywords
• System Tables
• Table Functions
• Information Schema

Considerations

Case Sensitivity: Dremio does not support case-sensitive data file names, table names, or column names.

• For example, if you have three file names that have the same name, but with different cases (such as, MARKET, Market, and market), Dremio is unable to discern the case differences, resulting in unanticipated data results.
• For column names, if two columns have the same name using different cases (such as Trip_Pickup_DateTime and trip_pickup_datetime) exist in the table, one of the columns may disappear when the header is extracted.

Additional Resources

Learn more about using SQL by enrolling in the SQL for Data Analysts course in Dremio University.