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 [1]), 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.
LINKS:
Relevant questions
Can we have the total amount divided into smaller parts and get charged via multiple cards?
asked 2 months agoPowerBI access to S3/Athena
Accepted Answerasked 3 years agoAccess Denied Error in Athena query file
asked 3 months agoAthena ODBC - Multiple Catalogs
asked 2 months agoAthena ODBC Connector for Power BI
asked 5 months agoCross account access from Athena to S3
Accepted Answerasked 3 years agoUnable to read Hive Acid tables in Athena using Athena Hive data connector
asked 25 days ago[AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Connecting to Amazon Athena Data Source
Accepted Answerasked 4 months agoNeed help troubleshooting Athena/ODBC error
Accepted Answerasked 2 years agoCan we connect multiple File Gateways to one FSx ?
Accepted Answerasked 2 months ago