aschreiber1 opened a new issue, #2545:
URL: https://github.com/apache/arrow-adbc/issues/2545
### What happened?
I have permissions to insert into a table, but it appears i cant used
adbc_ingest to append into the table as well, as I get does not exist or not
authorised exception. I have the create stage permissions that the
documentations say you need.
cursor.execute("Create table my_test (SECURITYID NUMBER)")
table = pa.table({
'SECURITYID': pa.array([1001, 1002, 1003, 1004, 1005], type=pa.int64())
})
//this works
for row in table.to_pylist():
cursor.execute(
"INSERT INTO my_test (SECURITYID) VALUES (?)",
(row['SECURITYID'],)
)
//this does not work
res = cursor.adbc_ingest("my_test", table, mode="append")
time="2025-02-22T01:45:56Z" level=error msg="error: 002003 (42S02): SQL
compilation error:\nObject '\"my_test2\"' does not exist or not authorized."
func="gosnowflake.(*snowflakeConn).queryContextInternal"
file="connection.go:413"
### Stack Trace
_No response_
### How can we reproduce the bug?
time="2025-02-22T01:45:56Z" level=error msg="error: 002003 (42S02): SQL
compilation error:\nObject '\"my_test2\"' does not exist or not authorized."
func="gosnowflake.(*snowflakeConn).queryContextInternal"
file="connection.go:413"
### Environment/Setup
python snowflake driver, ive tried with both 1.3 and 1.4 and same issue
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
