`unbase64` function

Applies to: check marked yes 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