search

snowflakedb / dplyr-snowflakedb

SnowflakeDB backend for dplyr
Apache License 2.0
65 stars 25 forks source link

SELECT * FROM "..." AS "zzz2" LIMIT 0 #11

Closed aaronbarnett closed 5 years ago

aaronbarnett commented 5 years ago

I've got a connection setup between RStudio and Snowflake. When I initiate a table view I receive and error.

sessions = tbl(sf, "sessionview")

Error in .verify.JDBC.result(r, "Unable to retrieve JDBC result set for ", : Unable to retrieve JDBC result set for SELECT * FROM "sessionview" AS "zzz2" LIMIT 0 (SQL compilation error: Object '"sessionview"' does not exist.)

If I run SELECT * FROM "sessionview" AS "zzz2" LIMIT 0 in snowflake it fails because it does not like the quotes. The modified query SELECT * FROM sessionview AS "zzz2" LIMIT 0 runs fine in snowflake.

How can I get dplr to not use quotes on the table name?

R-3.4.3 snowflake-jdbc-3.6.9.jar windows 10

aaronbarnett commented 5 years ago

Heard back from SF support...

Having the table name in quotes makes it case sensitive. All the table names are usually stored in UPPER CASE

confirmed: works with table names in all caps.