Athena ODBC - Multiple Catalogs
Hello. We have multiple catalogs (data source) in Athena that we would like to access in Power BI. We have set up an ODBC connection and include authentication option -- tested the connection successfully. In Power BI service, we can only see AWSDataCatalog. I found the following post on a workaround: https://repost.aws/questions/QUmVMMXsHoT6qdsr0D4NYSWg/athena-odbc-connector-for-power-bi
Essentially, we would need to write an SQL statement. Our desired state is to be able to return all our catalogs in Power BI (two of these are also cross account). When I wrote the following query in the SQL Statement section, I receive an error: select * from xacc_athena_data_catalog
An exception occurred: ODBC: ERROR (1040) An error has been thrown from the AWS Athena client. Error Message: SYNTAX_ERROR: line 1:15: Table xacc_athena_data_catalog.default.xacc_athena_data_catalog does not exist
Looking for suggestions to expose all the catalogs in Power BI service through Athena ODBC. Thank you!
Could you please enable the driver debug logging in ODBC Data Source Administrator (page 33 in documentation ), then re-run the query and upload the driver logs in a support case with Athena support team ? We can debug the issue and raise a request with development team if needed.
Can we have the total amount divided into smaller parts and get charged via multiple cards?asked 2 months ago
PowerBI access to S3/AthenaAccepted Answerasked 3 years ago
Access Denied Error in Athena query fileasked 3 months ago
Athena ODBC - Multiple Catalogsasked 2 months ago
Athena ODBC Connector for Power BIasked 5 months ago
Cross account access from Athena to S3Accepted Answerasked 3 years ago
Unable to read Hive Acid tables in Athena using Athena Hive data connectorasked 25 days ago
[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data SourceAccepted Answerasked 4 months ago
Need help troubleshooting Athena/ODBC errorAccepted Answerasked 2 years ago
Can we connect multiple File Gateways to one FSx ?Accepted Answerasked 2 months ago