random function
Applies to: 
Databricks SQL Databricks Runtime
Returns a random value between 0 and 1. This function is a synonym for rand function.
Syntax
random( [ seed ] )
Arguments
seed: An optionalINTEGERliteral.
Returns
A DOUBLE.
The function generates pseudo random results with independent and identically distributed uniformly distributed values in [0, 1).
This function is non-deterministic.
Examples
SQL
> SELECT random();
0.9629742951434543
> SELECT random(0);
0.8446490682263027
> SELECT random(null);
0.8446490682263027