Skip to content

Instantly share code, notes, and snippets.

@rizz0

rizz0/fixed.sql

Last active March 11, 2020 14:49
Show Gist options
  • Save rizz0/1cfb92f3864e04008f06a5b248c45e09 to your computer and use it in GitHub Desktop.
Save rizz0/1cfb92f3864e04008f06a5b248c45e09 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
fixed.sql
CREATE OR REPLACE FUNCTION `bigquery-project.dataSet.countParticipants`
(
arr STRUCT<name STRING, score FLOAT64>
)
RETURNS NUMERIC LANGUAGE js AS """
return arr.length;
""";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment