[BigQuery] Parameter type must be provided for empty array values

Queries and Resources
,
1

Unable to get this query working, any ideas?

SELECT
  DATE(TIMESTAMP) AS DAY,
  COUNT(DISTINCT jobId) AS num_jobIds
FROM
  cli_analytics.ReviewingActivity
WHERE
  timestamp BETWEEN TIMESTAMP({{ dateRangeSelect.value.start }}) AND TIMESTAMP({{ dateRangeSelect.value.end }})
  AND (
    {{!select1.value}}
     OE organizationId IN UNNEST({{ organizationSelect.value}})
  )
GROUP BY
  DAY

Screen Shot 2024-01-23 at 12.40.11 AM
Screen Shot 2024-01-23 at 12.40.11 AM956×1190 103 KB

2

@victoria I saw your thread Parameter types must be provided for null values via the 'types' field in query options - #29 by victoria. Can you please help out with this as well?

3

Can anyone help out here. It is blocking a production integration.

4

Maybe a stupid question but... are there nulls in the organizationSelect array?

Maybe another stupid question (not a BQ user) but doesn't the DATE function there need a column name to run against?

5

+1 on this issue. None of the solutions proposed in past threads about the topic have worked.