BigQuery - Convert Bytes to BASE64 or HEX String

Raymond Raymond
Raymond
Stats
articleArticles 554
codeCode 5
imageDiagrams 52
descriptionNotebooks 0
chat_bubble_outlineThreads 8
commentComments 296
loyaltyKontext Points 6161
account_circle Profile
visibility 2,733 event 2021-09-18 access_time 3 years ago language English
share
Twitter Facebook LinkedIn
more_vert
arrow_upward arrow_downward
BigQuery - Convert Bytes to BASE64 or HEX String

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:

20210918113747-image.png

JSON result:

[{"BASE64": "kC+90rHfDE9wtKXSNSXpMg==","HEX": "902fbdd2b1df0c4f70b4a5d23525e932"}]
More from Kontext
copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts