CodeX
Published in

CodeX

“NORMALIZE AND CASEFOLD” in BigQuery

How to improve Data Quality when working with Strings

Photo by Amanda Jones on Unsplash

With the BigQuery SQL function NORMALIZE_AND_CASEFOLDyou have a wonderful possibility to work with strings with different Unicode encodings.

What was Unicode and the different Encodings again?

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christianlauer

Christianlauer

Big Data Enthusiast based in Hamburg and Kiel. Thankful if you would support my writing via: https://christianlauer90.medium.com/membership