如何使用Simba ODBC连接到Amazon Athena [英] How to connect to Amazon Athena using Simba ODBC

问题描述

我正在尝试使用DBI :: dbConnect从RStudio连接到Athena，并且在打开驱动程序时遇到问题。

I am attempting to connect to Athena from RStudio using DBI::dbConnect, and I am having issues with opening the driver.

con <- DBI::dbConnect(
  odbc::odbc(),
  Driver             = "[Simba Athena ODBC Driver]",
  S3OutputLocation   = "[s3://bucket-folder/]",
  AwsRegion          = "[region]",
  AuthenticationType = "IAM Credentials",
  Schema             = "[schema]",
  UID                = rstudioapi::askForPassword("AWS Access Key"),
  PWD                = rstudioapi::askForPassword("AWS Secret Key"))
Error: nanodbc/nanodbc.cpp:983: 00000: [unixODBC][Driver Manager]Can't open lib '[Simba Athena ODBC Driver]' : file not found

在另外，此代码不返回任何内容。

In addition, this code returns nothing.

sort((unique(odbcListDrivers()[[1]])))
character(0)

看来我的ODBC驱动程序不可访问o r安装不正确，但我无法理解原因。我已经下载了驱动程序，并且可以在我的库中看到它。

It appears that my ODBC driver is unaccessible or incorrectly installed, but I am having trouble understanding why. I have downloaded the driver and can see it in my library.

任何见解都会受到赞赏！

Any insight is greatly appreciated!

推荐答案

函数参数看起来很奇怪。从 Driver ， S3OutputLocation 和<$中删除 [] c $ c> AwsRegion 。

The function arguments look strange. Remove the [] from Driver, S3OutputLocation and AwsRegion.

这篇关于如何使用Simba ODBC连接到Amazon Athena的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！