BI tool redash cannot parse unicode chinese

Question

I want to query a column in Redash with SQL, but it does not support Chinese. Can anybody help me? Thanks!

SELECT user_history.id, user_history.user_id AS `汉字id`
FROM data_platform.user_history
WHERE dt = {{ dt}}

Answer 1

Your formatting of 汉字id was not correct. Below query will work on an MySQL database, but not necessarily with Google BigQuery.

SELECT user_history.id, user_history.user_id AS '汉字id'
FROM data_platform.user_history
WHERE dt = {{ dt}}