python snowflake adbc_ingest "<Table>does not exist or not authorized"
- Dominant language
- C#
- Stars
- 627
- Forks
- 217
- Avg merge
- 17h
- Merged PRs (30d)
- 57
Description
### 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
Contributor guide
Assessment
This issue has not been assessed yet.