liamnz opened a new issue, #2366:
URL: https://github.com/apache/arrow-adbc/issues/2366
### What happened?
I'm using the `adbcdrivermanager` and `adbcsnowflake` packages in R and
testing out writing a data-frame to a Snowflake table with `write_adbc()`.
`write_adbc()` returns a NOT_FOUND error from Snowflake.
It looks like the table gets created, but the actual data is not written to
the table.
### Stack Trace
_No response_
### How can we reproduce the bug?
```r
install.packages('adbcdrivermanager')
#> package 'adbcdrivermanager' successfully unpacked and MD5 sums checked
install.packages("adbcsnowflake", repos =
"https://community.r-multiverse.org";)
#> package 'adbcsnowflake' successfully unpacked and MD5 sums checked
library(adbcdrivermanager)
library(adbcsnowflake)
db <- adbc_database_init(
adbcsnowflake(),
username = Sys.getenv('SNOWFLAKE_USER'),
adbc.snowflake.sql.account = Sys.getenv('SNOWFLAKE_ACCOUNT'),
adbc.snowflake.sql.uri.protocol = 'https',
adbc.snowflake.sql.uri.host = paste0(Sys.getenv('SNOWFLAKE_ACCOUNT'),
'.snowflakecomputing.com'),
adbc.snowflake.sql.uri.port = '443',
adbc.snowflake.sql.auth_type = 'auth_ext_browser',
adbc.snowflake.sql.role = Sys.getenv("SNOWFLAKE_ROLE"),
adbc.snowflake.sql.warehouse = Sys.getenv("SNOWFLAKE_WAREHOUSE"),
adbc.snowflake.sql.db = Sys.getenv("SNOWFLAKE_DATABASE")
)
con <- adbc_connection_init(db)
execute_adbc(con, 'create or replace schema reprex')
execute_adbc(con, 'use schema reprex')
write_adbc(mtcars, con, 'MTCARS')
#> Error in adbc_statement_execute_query(stmt): NOT_FOUND: 002003 (42S02):
SQL compilation error:
#> Object 'MTCARS' does not exist or not authorized.
schema_tables <- as.data.frame(read_adbc(con, 'show tables in schema
reprex'))
#> Warning in convert_array_stream(x, to): 1 value(s) may have incurred loss
of
#> precision in conversion to double()
schema_tables[, c('name', 'rows')]
#> name rows
#> 1 MTCARS 0
as.data.frame(read_adbc(con, 'select * from mtcars'))
#> [1] mpg cyl disp hp drat wt qsec vs am gear carb
#> <0 rows> (or 0-length row.names)
```
Created on 2024-12-13 with [reprex v2.1.1](https://reprex.tidyverse.org/)
### Environment/Setup
Windows 11
R 4.4.2
adbcdrivermanager 0.15.0
adbcsnowflake 0.15.0
--
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]
