Forum Discussion
DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS
Hi all,
I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop.
At this stage, I have connected to the data source with the following message:
SUCCESS!
Successfully connected to data source!
ODBC Version: 03.80
Driver Version: 1.1.20.1003
Bitness: 64-bit
Locale: en_AU
However, when I viewed one of the tables within AwsDataCatalog, I get an following error message:
DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWS Athena client. Error Message: HIVE_UNSUPPORTED_FORMAT: Unable to create input format
Then when I clicked on another file ending with ‘_csv’, I can see the list of data field names but with no data.
Our IT consultant is trying to work out whether it is permissions within the policy configuration that is needed, or is it on my side that some configuration is required.
Appreciate for any assistance.
2 Replies
Hi JohnCYY238,
According to the error message, this issue seems more related to athena, you can try following options if helps:
1. The credentials are vailed and have permissions to access Athena.
2. The query syntax is correct.
3. The query is too complex and can be executed within the timeout limit.
4. Check the network connection status if it is stable enough and not dropping packets.
5. Check if the query if it hit any resource , concurrency, data size, query execution limits.
Regards,
Xiaoxin Sheng
You will need to add this policy in your athena for the access key that you have received while logging in the ODBC ...... replace the arn with your arn
below is the code you can copy
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"athena:StartQueryExecution",
"athena:GetQueryExecution",
"athena:GetQueryResults"
],
"Resource": "*"
}
]
}
