unbase64 function
Applies to: 
Databricks SQL Databricks Runtime
Returns a decoded base64 string as binary.
unbase64(expr)
expr: A STRING expression in a base64 format.
A BINARY.
SQL
> SELECT cast(unbase64('U3BhcmsgU1FM') AS STRING);
Spark SQL