Problem:
Need to call a procedure to update data in a Google BigQuery data source.
This used to work for other data sources by using a pre-query like this:
call `xxx.yyy.proc_zzz`(?param)
With the Simba BigQuery JDBC Connector 1.5.4, you get the following error:
InformationModelException at Spotfire.Dxp.Data:
Failed to execute query: [Simba][JDBC](11320) A RowCount was expected but not generated from query "call `xxx.yyy.proc_zzz`('test')". (HRESULT: 80131500)
Solution:
In Information Designer edit dialog box for the query, move the query call to the post-query, from the pre-query.
This box will be hidden from the public.
Source Case 295505