Hi. I don’t seem to be able to use parametrized BigQuery queries using DBeaver w. Simba JDBC driver.
This google reference BigQuery JDBC drivers states “the drivers support positional parameterization”.
When I try to execute a query using a question mark (?) as placeholder i get the following message:
“Positional parameters are not supported at [3:23]”.
If I try to use named parameters (i.e. @ param) , on the other end, I get the following message:
“Query parameter ‘param’ not found at [3:23]”.
I could not find a way to supply named query parameters through DBeaver / Simba configuration.
It is quite important, as when using a parameter, the provided value itself is not logged in the BigQuery logs to protect potentially sensitive information, like for instance for using a DEK wrapper in client-side column encryption.
Has somebody found a way to make it work ?