Integrations / Amazon Athena

Connect

Amazon Athena

with ToolJet

ToolJet’s Amazon Athena integration lets you run SQL queries on your S3 data directly from your internal tools, ideal for analytics, monitoring, and reporting.

Docs

Available actions with ToolJet and Amazon Athena integration

ToolJet's integration with Amazon Athena supports various operations:

Connect securely to Athena

Connect to Athena by providing your database name, S3 output location, AWS access key, secret key, and region. Optional parameters can be configured for more granular control.

Run SQL queries

Write and run custom SQL queries from the query panel. Retrieve, filter, and transform your S3-stored data using standard SQL, ideal for dynamic dashboards or data audits.

Create external tables

Use CREATE EXTERNAL TABLE statements to define tables based on data stored in S3 buckets. Easily map your unstructured files into queryable tables.

Insert and update data

Execute INSERT INTO queries to add new records into Athena-managed tables, making it easy to simulate database operations on S3-based data lakes.

Retrieve and filter data

Use SELECT statements to fetch and filter records, great for pulling insights, populating tables, or powering custom visualizations.

Browse available tables

Run SHOW TABLES to explore available tables within your Athena database, helping you quickly understand your data structure and schema.

Why use ToolJet with Amazon Athena

AI-powered app building

Build internal tools, workflows, and AI agents in hours using plain English. Go from idea to production with AI-generated apps, data models, and instant debugging.

Enterprise-grade security and compliance

Stay secure with SSO, RBAC, audit logs, encryption, and compliance standards like SOC2, ISO 27001, and GDPR. Deploy your way: cloud, on-prem, or hybrid.

Production-ready database and integrations

Skip setup hassles with instant PostgreSQL and pre-built integrations for AI, databases, storage, and APIs.

Components and environment management

Speed up development with 60+ pre-built components and manage releases across dev, test, and production environments.

Flexible development options

Use no-code visual builders, or dive into low-code, and switch seamlessly as your needs evolve. You have full control, and there is no lock-in.

JavaScript and Python

Write custom logic and data transformations using JavaScript or Python, flexible scripting built right in.

Explore more API integrations

Frequently asked questions

1. What is the difference between Amazon Athena and Amazon Redshift?

⌄

⌃

Amazon Athena is a serverless query service that analyzes data directly in Amazon S3 using SQL, while Amazon Redshift is a fully managed data warehouse optimized for complex queries on structured data.

2. How does Amazon Athena integrate with Amazon QuickSight?

⌄

⌃

Amazon Athena can be used as a data source in Amazon QuickSight, enabling users to visualize and analyze S3 data through interactive dashboards without managing servers.

3. How is Amazon Athena used in building data platforms?

⌄

⌃

Amazon Athena is commonly used to build lightweight, scalable analytics platforms by querying data lakes on S3, integrating with Glue for ETL, and feeding insights into tools like QuickSight.

4. What are Athena connectors, and how do they work?

⌄

⌃

Athena connectors extend Athena's capabilities by allowing it to query data from external sources like MySQL, PostgreSQL, and DynamoDB using AWS Glue Data Catalog and Lambda.