如何检查字符串是否是BigQuery中的iOS唯一识别器

Question

如何检查字符串是否为iOS唯一设备标识符？

这与这个问题相似，除了我在BigQuery SQL中寻找答案，最好是在#StandardSQL中。

SELECT something FROM table WHERE IsUniqueidentifier(column) = 1

Answer 1

#StandardSQL
WITH data AS
  (SELECT "4CE798CD-D691-44D2-9FFA-EC440256B933" as string
  UNION ALL
  SELECT "597CCBE1-4388-423B-A6A9-03F7276B1861" as string
  UNION ALL
  SELECT "1AC8A2BB-E263-488B-A81C-774B659D7EE5" as string
  union all 
  SELECT "so long and thanks for all the fish" as string)
SELECT
  string AS valid_string
FROM data
  WHERE REGEXP_REPLACE(string, r'[0-9a-fA-F]', '0') 
  LIKE '00000000-0000-0000-0000-000000000000'

Answer 2

我将使用 regexp_contains()：

where regexp_contains(string, '^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}')