Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Installing Athena ODBC Driver on Mac OS

0

Hi, I downloaded Athena ODBC Driver on Mac OS through the link I found that it requires additional configuration to use this driver on Mac os.

In order to do that, I need to copy the license file to /Library/simba/athenaodbc path but I can't find this file and didn't receive it through email as well. Please advise how I can finish the configuration to use the driver.

Topics
Analytics
Tags
Amazon Athena
Language
English
asked 3 years ago1.6K views
1 Answer
2

Download OSX Driver from the link

https://docs.aws.amazon.com/athena/latest/ug/connect-with-odbc.html

And Follow the configuration guide for MAC OSX from the document

https://s3.amazonaws.com/athena-downloads/drivers/ODBC/SimbaAthenaODBC_1.1.19.1002/docs/Simba+Amazon+Athena+ODBC+Connector+Install+and+Configuration+Guide.pdf

And Configure the Driver as in the document section

Configuring the ODBC Driver Manager on Non-Windows Machines

EXPERT
answered 3 years ago
  • rePost-User-8135854
    3 years ago

    Hi, Thanks for your comment yet I still couldn't handle the issue. I modified both odbc.ini and odbcinst.ini files as below based on the docs but I still cannot load the driver with an error message: 'specified driver could not be loaded'.

    /Library/simba/athenaodbc/Setup/odbc.ini

    [Simba Athena]
Driver=/Library/simba/athenaodbc/lib/libathenaodbc_sbu.dylib
AuthenticationType=IAM Credentials
UID=${Access key}
PWD=${Secret key}
AwsRegion=us-east-2
S3OutputLocation=s3://test/

    /Library/simba/athenaodbc/Setup/odbcinst.ini

    [ODBC Drivers]
Simba Athena ODBC Driver=Installed

[Simba Athena ODBC Driver]
Description=Simba Athena ODBC Driver
Driver=/Library/simba/athenaodbc/lib/libathenaodbc_sbu.dylib

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content