Other Functions
This section collects assorted utilities that do not fit into the major functional groups.
| Function | Description |
|---|
| ASSUME_NOT_NULL | Hint that values in a nullable column are never NULL |
| EXISTS | Return TRUE if a subquery produces any rows |
| GROUPING | Reveal whether an output column was aggregated in GROUPING SETS |
| HUMANIZE_NUMBER | Format large numbers with unit suffixes |
| HUMANIZE_SIZE | Format byte counts into readable units |
| READ_FILE | Read a file from a stage and return its raw bytes |
| REMOVE_NULLABLE | Strip NULLability from a column value |
| TO_NULLABLE | Convert a value to a nullable type |
| TYPEOF | Return the name of a value’s data type |