When you use parameters for BigQuery SQL query like below, you might see error something like this.
Error in bq_job_wait(job, quiet = quiet) : Job '' failed with Invalid integer literal
And you use the parameter UserID like below.
Select * from ...
where userId = @{UserID} AND
status = "CONFIRMED"
for this case, you might want to change your SQL query as follow by CASTING the colum as STRING.
Select * from ...
where CAST(userId as STRING) = CAST(@{UserID} as STRING) AND
status = "CONFIRMED"