- 최신
- 최다 투표
- 가장 많은 댓글
Hello,
we can use the ODBC connection to connect to Amazon Athena from third-party SQL client tools and applications. Having said that, I suspect from the Microsoft documentation - If the external database that you want to access is not supported by the ODBC drivers that are installed with Microsoft Query, then you need to obtain and install a Microsoft Office-compatible ODBC driver from a third-party vendor, such as the manufacturer of the database. Contact the database vendor for installation instructions.
Hence while connecting it would be appropriate to use From Other Sources / ODBC to athena rather than directly doing it from / From Other Sources / MSQuery which the driver might not be compatible with.
Thank you!
References: [1]https://support.microsoft.com/en-us/office/use-microsoft-query-to-retrieve-external-data-42a2ea18-44d9-40b3-9c38-4c62f252da2e - External docs [2]https://www.linkedin.com/pulse/connecting-athena-through-excel-philip-vago -External docs
관련 콘텐츠
- AWS 공식업데이트됨 3년 전
- AWS 공식업데이트됨 2년 전