BigQuery "Parameterized query job" using the python client library

Question

I have been trying to run a parameterized query using the client libraries in Python and I have tried both the named parameters and the positional parameters methods in the documentation, but neither of them worked.

Here's the positional parameters method:

And the output:

The code compiles with no error when I remove the last line of code:

I have a different function that does not use a parameterized query and works just fine:

How can I parameterize it with "id"?

I have tried the named parameters and the positional parameters methods described in the documentation but neither of them worked. I'm expecting to get data for the specific id parameter and put it in a data frame.

Answer 1

Try removing squar brackets from table name clause.

change

• select * from [ Table_name ]

to this

• select * from Table_name