SELECT *
FROM `fao-maps-review.fao_famews.vw_scouts_lat_lon`
where case when @dim_country = 'All Countries' then true else country=@dim_country end and
survey_date >= @start_date and survey_date <= @end_date
LIMIT 50000
400 Query parameter 'dim_country' not found at [3:17]
Location: EU
Job ID: 0b0eb6c5-6f6f-425f-9ca6-d038dc3bf7bd
Reason | Location | Message |
---|---|---|
invalidQuery | query | Query parameter 'dim_country' not found at [3:17] |