Search code examples
google-bigquerylooker-studio

Big Query do not accept EMOJI

I have emojis in this format - \U0001f924 why BigQuery(Google Data studio) does not display them, even if I saw examples that this format working for other people?

SAMPLE: - Second Emoji in this format \u2614 enter image description here

Ref: Emoji crashed when uploading to Big Query

Based on this article it should work: Google \Uhhhhhhhh Format enter image description here

UPDATE 1.0:

If I use "" then emojis in this format \U2714 displays emoji, this one \U0001f680 still the same as text U0001f680

If I use '' then emojis in this format \U2714 as well as \U0001f680 display only value U2714 and U0001f680

Solution

  • The emoji on the question works for me with SELECT "\U0001f680":

    enter image description here

    I stored the results in a table so you can find it:

    If you ask BigQuery to export this table to a GCS file, and bring this file into your computer, it will continue to work:

    enter image description here

    You can download this json file and load it back into BigQuery:

    Let's load it into BigQuery:

    enter image description here

    Everything works fine:

    enter image description here

    So the problem is in the files you are loading to BigQuery - which are not encoding emoji's appropriately.

    What I don't know is how you are generating these files, nor how to fix that process. But here I have proven that for files that correctly encode emojis - you can load them into BigQuery and emojis will be preserved.

    🙃