[I] BigQuery Ingest Does Not work [arrow-adbc]

[via GitHub]

WillAyd opened a new issue, #2172:
URL: https://github.com/apache/arrow-adbc/issues/2172

   ### What happened?
   
   When trying to ingest data into BigQuery I get a `ProgrammingError: 
INVALID_ARGUMENT: unknown statement string type option 
adbc.ingest.target_table` error
   
   ### Stack Trace
   
   ```
   Cell In[29], line 14
        11 tbl = pa.Table.from_pydict({"col": [0, 1, 2]})
        13 with adbc_driver_bigquery.dbapi.connect(db_kwargs) as conn, 
conn.cursor() as cur:
   ---> 14     cur.adbc_ingest(table_name="foo", data=tbl)
   
   File 
~/clones/arrow-adbc/python/adbc_driver_manager/adbc_driver_manager/dbapi.py:895,
 in Cursor.adbc_ingest(self, table_name, data, mode, catalog_name, 
db_schema_name, temporary)
       891 if db_schema_name is not None:
       892     options[
       893         
adbc_driver_manager.StatementOptions.INGEST_TARGET_DB_SCHEMA.value
       894     ] = db_schema_name
   --> 895 self._stmt.set_options(**options)
       897 if temporary:
       898     self._stmt.set_options(
       899         **{
       900             
adbc_driver_manager.StatementOptions.INGEST_TEMPORARY.value: "true",
       901         }
       902     )
   
   File 
~/clones/arrow-adbc/python/adbc_driver_manager/adbc_driver_manager/_lib.pyx:1482,
 in adbc_driver_manager._lib.AdbcStatement.set_options()
   
   File 
~/clones/arrow-adbc/python/adbc_driver_manager/adbc_driver_manager/_lib.pyx:260,
 in adbc_driver_manager._lib.check_error()
   
   ProgrammingError: INVALID_ARGUMENT: unknown statement string type option 
`adbc.ingest.target_table`
   > 
/home/demo/code/adbc14/adbc_driver_manager/_lib.pyx(260)adbc_driver_manager._lib.check_error()
   ```
   
   ### How can we reproduce the bug?
   
   ```python
   import adbc_driver_bigquery.dbapi
   from adbc_driver_bigquery import DatabaseOptions
   import pyarrow as pa
   
   db_kwargs = {
       DatabaseOptions.PROJECT_ID.value: "some-demo-project-1234",
       DatabaseOptions.DATASET_ID.value: "demo_dataset",
       DatabaseOptions.TABLE_ID.value: "foo",
   }
   
   tbl = pa.Table.from_pydict({"col": [0, 1, 2]})
   
   with adbc_driver_bigquery.dbapi.connect(db_kwargs) as conn, conn.cursor() as 
cur:
       cur.adbc_ingest(table_name="foo", data=tbl)
   ```
   
   ### Environment/Setup
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org