What is the function to get the number of elements in a JSON array in Databricks SQL?
The function to get the number of elements in a JSON array in Databricks SQL is `json_array_length()`. This function returns an INTEGER representing the number of elements in the outermost JSON array. If the input is not a valid JSON string or NULL, the function returns NULL.