I am trying to use SqlRender and SAMBA JDBC library to talk to BigQuery. SELECT works fine. But, INSERT is causing error with [Simba]JDBC Driver does not support this optional feature. I did Google search, and it seems like it’s because of connection’s autocommit feature, which we can’t turn it off with SAMBA BigQuery JDBC library.
In GitHub for OHDSI, the Database Connector repo just ignores the exception.
Does anyone have a fix for this? I can’t find the fix from google search. I hope developers here may have a fix for this.