@Luiggi
here is the example query -
SELECT
payment_group.name AS name,
payment_group.rev_type as rev_type,
payment_group.id as publisher_id,
FROM epic.publisher
LEFT JOIN epic.publisher AS payment_group ON publisher.payment_group = payment_group.id
where {{publisher.name}}
Whenever I'm selecting anything values from the dropdown getting the below error -
400 Bad Request POST https://www.googleapis.com/bigquery/v2/projects/epic-jenkins/queries { "code" : 400, "errors" : [ { "domain" : "global", "location" : "q", "locationType" : "parameter", "message" : "Syntax error: Expected end of input but got keyword WHERE at [2:1]", "reason" : "invalidQuery" } ], "message" : "Syntax error: Expected end of input but got keyword WHERE at [2:1]", "status" : "INVALID_ARGUMENT" }