dbAppendTable takes ~ 30 seconds in Snowflake

[eriksquires]

There seems to be some sort of constant time work happening. The amount of time whether 5 records or 5000 records remains around 30 seconds.

In Snowflake:

create schema r_testing;

create or replace TABLE R_TESTING.TINY (
    PRODUCT_ID NUMERIC
);

In R:

con <- dbConnect()

df <- data.frame(PRODUCT_ID=1:5)

dbAppendTable(con, "TINY", df)

[eriksquires]

Sorry, I guess this should be against ODBC and not DBI. My bad.