klin333 opened a new issue, #2633:
URL: https://github.com/apache/arrow-adbc/issues/2633
### What feature or improvement would you like to see?
It's been a while since adbc.ingest.temporary was introduced. Any chance
support can be added to snowflake driver?
```{r}|
library(adbcdrivermanager)
uri <- "secret"
db <- adbc_database_init(adbcsnowflake::adbcsnowflake(), uri = uri)
con <- adbc_connection_init(db)
datasets::iris |> write_adbc(con, "TEST1234", temporary = TRUE)
# Error in adbc_statement_set_options(statement, options) :
# NOT_IMPLEMENTED: [Snowflake] Unknown statement option
'adbc.ingest.temporary'
```
i suppose I can work around it. i'm not sure if this has equivalent
performance, seems so?
```
con <- DBI::dbConnect(adbi::adbi("adbcsnowflake::adbcsnowflake"), uri =
'secret')
tbl_name <- 'TEST1234'
df <- datasets::iris
sql <- DBI::sqlCreateTable(con, tbl_name, df, row.names = FALSE, temporary =
TRUE)
DBI::dbExecute(con, sql)
DBI::dbWriteTable(con, tbl_name, df, append = TRUE)
tbl_obj <- tbl(con, tbl_name)
```
--
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
