1

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

oguz ismail
  • 1
  • 16
  • 47
  • 69

1 Answers1

0

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.

Felipe Hoffa
  • 54,922
  • 16
  • 151
  • 325
  • Ye, I have just tested this ..... what I do is, I'm taking this "emoji_icon":"\U0001f44d\U0001f3fb", and upload to BigQuery with JSON auto detect schema (emoji is a STRING) –  Sep 06 '18 at 10:06
  • 1
    That's not a nicely encoded file. I don't know how you are creating these files, and I don't know how to nicely encode them either. – Felipe Hoffa Sep 06 '18 at 10:07