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