With Athena, users can define the schema pointing to data on S3, and query data using SQL. This makes it easy for anyone with SQL skills to quickly analyze large-scale datasets on S3.
Athena is based on the Presto distributed SQL engine and can query data in many different formats including JSON, CSV, log files, text with custom delimiters, Apache Parquet, and Apache ORC.
DBHawk enables various organizations to give and get complete data access on Amazon S3.
You can connect to S3 data with DBHawk by using S3 staging directory to store query results, AWS access key as the username and AWS secret key for the password.
DBHawk provides robust SQL query editor for Athena S3 data. With DBHawk query editor, users can write and run various queries against the database, create SQL snippets and give secure query access to other users. DBHawk SQL share feature allows users to share SQL query with other users.
With DBHawk charts and dashboard builders, users can run SQL queries, create various data visualizations, build live data dashboards, and share built dashboards with other users.
With DBHawk visual data browser, browse and filter data with built-in data filter.
The S3 data export tool in DBHawk allows users to export data from S3 in various formats such as delimited files, Excel spreadsheets, HTML, PDF and directly storing data in AWS S3.
The Table columns viewer and SQL generator allow users to view Athena table definition and also generates SQL DDL for the table.