ASSUME_NOT_NULL
Learn how to use the ASSUME_NOT_NULL utility function in PlaidCloud Lakehouse. Results in an equivalent non-Nullable value for a Nullable type.
Other Functions
This section provides reference information for other miscellaneous functions in PlaidCloud Lakehouse.
EXISTS
Learn how to use the EXISTS utility function in PlaidCloud Lakehouse. The exists condition is used in combination with a subquery and is considered "to be...
GROUPING
Learn how to use the GROUPING utility function in PlaidCloud Lakehouse. Returns a bit mask indicating which GROUP BY expressions are not included in the...
HUMANIZE_NUMBER
Learn how to use the HUMANIZE_NUMBER utility function in PlaidCloud Lakehouse. Returns a readable number. Includes usage and syntax details.
HUMANIZE_SIZE
Learn how to use the HUMANIZE_SIZE utility function in PlaidCloud Lakehouse. Returns the readable size with a suffix(KiB, MiB, etc). With syntax and examples.
IGNORE
Learn how to use the IGNORE utility function in PlaidCloud Lakehouse. By using insert ignore statement, the rows with invalid data that cause the error are...
REMOVE_NULLABLE
Learn how to use REMOVE_NULLABLE in PlaidCloud Lakehouse. Alias for the ASSUME_NOT_NULL utility function. Includes usage and syntax details.
TO_NULLABLE
Learn how to use the TO_NULLABLE utility function in PlaidCloud Lakehouse. Converts a value to its nullable equivalent. Includes syntax and examples.
TYPEOF
Learn how to use the TYPEOF utility function in PlaidCloud Lakehouse. TYPEOF function is used to return the name of a data type. Includes syntax and examples.