How do I connect to Athena?
Step-by-step Instructions
- Step 1: Create a Holistics User in Amazon IAM Console Add a user with ‘Programmatic Access’ in Amazon IAM Console.
- Step 2: Add AWS Athena Data Source Create an Athena database using AWS Athena Console.
- Step 3: Setup your Athena Instance for Querying
How does AWS Athena work?
Athena works directly with data stored in S3. Athena uses Presto, a distributed SQL engine to run queries. It also uses Apache Hive to create, drop, and alter tables and partitions. You can write Hive-compliant DDL statements and ANSI SQL statements in the Athena query editor.
How do I start Athena?
Getting started
- Step 1: Create a database. You first need to create a database in Athena.
- Step 2: Create a table. Now that you have a database, you can create an Athena table for it.
- Step 3: Query data.
What is Athena used for?
Amazon Athena is a service that enables data analysts to perform interactive queries in the web-based cloud storage service, Amazon Simple Storage Service (S3). Athena is used with large-scale data sets. Amazon S3 is designed for online backup and archiving of data and applications on Amazon Web Services (AWS).
What port does Athena use?
port 444
Athena’s streaming API uses port 444 to stream the query results.
How do I connect to Athena from SQL Workbench?
Download the Amazon Athena JDBC driver to the same computer where SQL Workbench is installed. In SQL Workbench, open File, Connect window, Manage Drivers. Choose the Athena driver and add two libraries, Athena JDBC driver and the custom credentials provider by specifying the location where you downloaded them.
Can I use Athena without glue?
After you upgrade to the AWS Glue Data Catalog, AWS Glue actions must be allowed for your users. Remember, the managed policy for Athena has already been updated to allow the required AWS Glue actions, so no action is required if you use the managed policy.
Does Athena only work with S3?
You don’t even need to load your data into Athena, it works directly with data stored in S3. To get started, just log into the Athena Management Console, define your schema, and start querying.
How do I make an Athena database?
Open the Athena console at https://console.aws.amazon.com/athena/ .
- On the Editor tab, enter the Hive data definition language (DDL) command CREATE DATABASE myDataBase .
- Choose Run or press Ctrl+ENTER .
- To make your database the current database, select it from from the Database menu on the left of the query editor.
How do you load data into an Athena table?
Amazon Athena now supports inserting new data to an existing table using the INSERT INTO statement. With this release, you can insert new rows into a destination table based on a SELECT query statement that runs on a source table, or based on a set of values that are provided as part of the query statement.
Can we delete data in Athena?
You can leverage Athena to find out all the files that you want to delete and then delete them separately. There is a special variable “$path”. To automate this, you can have iterator on Athena results and then get filename and delete them from S3.
What is Amazon Athena good for?
Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. Athena is easy to use.
How do I connect Athena to other data sources?
You can also connect Athena to a variety of data sources by using ODBC and JDBC drivers, external Hive metastores, and Athena data source connectors. For more information, see Connecting to Data Sources .
How can I ensure Athena access is secure?
For an example policy, see AWSQuicksightAthenaAccess Managed Policy. Additionally, ensure that port 444, which Athena uses to stream query results, is open to outbound traffic. When you use a PrivateLink endpoint to connect to Athena, ensure that the security group attached to the PrivateLink endpoint is open to inbound traffic on port 444.
How do I connect Athena to business intelligence tools?
You can use a JDBC connection to connect Athena to business intelligence tools and other applications, such as SQL Workbench.
How do I connect Athena to SQL Workbench?
Using Athena with the JDBC Driver. You can use a JDBC connection to connect Athena to business intelligence tools and other applications, such as SQL Workbench. To do this, download, install, and configure the Athena JDBC driver, using the following links on Amazon S3.
