[I] python snowflake adbc_ingest "does not exist or not authorized" [arrow-adbc]

Fri, 21 Feb 2025 17:55:32 -0800


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: issues-unsubscr...@arrow.apache.org.apache.org

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

Reply via email to