Amazon DataZone now supports authentication with the Athena JDBC Driver, enabling data consumers to query their project’s subscribed data lake assets in Amazon DataZone using popular BI and analytics tools such as Tableau, Domino, Power BI, MS Excel, SQL Workbench, and more. Data analysts and scientists can seamlessly access and analyze governed data in Amazon DataZone using a standard JDBC connection with their preferred tools.
To get started, users can download and install the latest Athena JDBC driver for their tool of choice. To establish a connection, they will copy the JDBC string from the DataZone portal into the JDBC connection configuration and authenticate using single sign-on with their corporate credentials. Once connected, they can query, visualize, and share data—governed by Amazon DataZone—within the tools they already know and trust.
This feature is now available in all the AWS commercial regions where Amazon DataZone is supported.
Check out this blog and video to learn more about how to connect Amazon DataZone to external analytics tools via JDBC. Get started with the technical documentation.
Source:: Amazon AWS