bigquery gcp sql

BigQuery - Convert Bytes to BASE64 or HEX String

event 2021-09-18 thumb_up 0 visibility 3,967 comment 0 insights

more_vert

warning Please login first to view stats information.

BigQuery - Convert Bytes to BASE64 or HEX String

Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.

Code snippet

BigQuery provides built-in functions to convert bytes to BASE64 or HEX string.

Code snippet

SELECT TO_BASE64(MD5('ABC')) AS BASE64, TO_HEX(MD5('ABC')) AS HEX;

Results:

JSON result:

[{"BASE64": "kC+90rHfDE9wtKXSNSXpMg==","HEX": "902fbdd2b1df0c4f70b4a5d23525e932"}]

copyright This page is subject to Site terms.

BigQuery - Convert Bytes to BASE64 or HEX String

insights Stats

Code snippet

Log in with external accounts

BigQuery - Convert Bytes to BASE64 or HEX String

insights Stats

Table of contents

Code snippet

Log in with external accounts