Skip to main content
Version: 2.4.0

Athena

ToolJet can connect to Amazon Athena which is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL.

Connection

ToolJet requires the following to connect to your Athena.

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

You can also configure for additional optional parameters.

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.
Athena query
  • Click on the run button to run the query.

NOTE: Query should be saved before running.

tip

Refer amazon athena docs here for more info: link

Basic queries

Creating table

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

Inserting to table

INSERT INTO student
VALUES ('Lansing',1)

Select operation

SELECT * from student WHERE AGE=1