Skip to content

Athena#

Insight² can connect to Amazon Athena databases to read and write data.

Connection#

Insight² requires the following to connect to your Athena.

  • Database
  • S3 output location
  • Access key
  • Secret key
  • Region

You can also configure for additional optional parameters.

Insight² - Amazon Athena - Connection

Querying Amazon Athena#

  • Click on + button of the query manager at the bottom panel of the editor and select the database added in the previous step as the datasource. Query manager then can be used to write SQL queries.

Insight² - Querying- Amazon Athena

  • Click on the run button to run the query.

NOTE: Query should be saved before running.

Refer amazon athena docs here for more info: link

Basic queries#

Refer amazon athena docs here for more info: link

Creating table#

1
2
3
4
CREATE EXTERNAL TABLE student (
    name STRING,
    age INT
)  LOCATION 's3://athena-express-akiatfa53s-2022/';

Inserting to table#

1
2
INSERT INTO student
VALUES ('Lansing',1)

Select operation#

1
SELECT * from student WHERE AGE=1