RoyalTS commented on issue #841:
URL: https://github.com/apache/arrow-adbc/issues/841#issuecomment-1669186462
I'm having similar/the same issues.
```r
db <- adbcdrivermanager::adbc_database_init(
adbcsnowflake::adbcsnowflake(),
username = '<my_username>,
adbc.snowflake.sql.account = "deliveroo.eu-central-1",
adbc.snowflake.sql.auth_type = "auth_ext_browser"
)
con <- adbcdrivermanager::adbc_connection_init(db)
```
results in
```r
time="2023-08-08T10:42:23+02:00" level=error msg="Authentication FAILED"
func="gosnowflake.(*defaultLogger).Errorln" file="log.go:242"
Error in force(code) :
[Snowflake] 390400 (08004): Bad request; operation not supported.
```
Following suggestions in thread and appending `.aws` to the account – I do
not believe this is the correct account, but whatever – results in the
operation waiting a long time to return but then eventually returning with
```r
Error in force(code) :
[Snowflake] Post
"https://deliveroo.eu-central-1.aws.snowflakecomputing.com:443/session/authenticator-request?requestId=e2b4ec97-827a-4056-729d-930d4ad03f3f":
tls: failed to verify certificate: x509: certificate is valid for
*.prod3.us-west-2.snowflakecomputing.com, *.us-west-2.snowflakecomputing.com,
*.global.snowflakecomputing.com, *.snowflakecomputing.com,
*.prod3.us-west-2.aws.snowflakecomputing.com, not
deliveroo.eu-central-1.aws.snowflakecomputing.com
```
which perhaps isn't surprising given it's not the correct account name.
The same credentials work swimmingly using the odbc driver.
--
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]
