search

snowflakedb / dplyr-snowflakedb

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

Valid regions out of date #18

Open Torvaney opened 5 years ago

Torvaney commented 5 years ago

Our Snowflake instance is located in eu-west-1; however, attempting to connect to that region with src_snowflakedb throws an error:

  Invalid 'region_id'. 
         See: https://docs.snowflake.net/manuals/user-guide/intro-editions.html#region-ids-in-account-urls

I think this is because the valid regions are out of date:

function (user = NULL, password = NULL, account = NULL, port = 443, 
  host = NULL, opts = list(), region_id = "us-west", ...) 
{
  requireNamespace("RJDBC", quietly = TRUE)
  requireNamespace("dplyr", quietly = TRUE)
  valid_regions = c("us-east-1", "eu-central-1", "ap-southeast-2")
# ...