To connect TextQL with Amazon Athena, you will need to set up appropriate AWS credentials and S3 access. Athena requires the following IAM permissions:
  • athena:StartQueryExecution
  • athena:GetQueryExecution
  • athena:GetQueryResults
  • s3:GetObject and s3:ListBucket for data locations
  • s3:PutObject for query results bucket
  • glue:GetTable and glue:GetPartitions (if using AWS Glue)

​
Creating the Connector in TextQL

Navigate to the TextQL Connectors Page and click Create New Connector. Select Amazon Athena from the available connectors to open the configuration form.
New Connector

Click Create Connector.

Select Amazon Athena from the available connectors to open the configuration form.
Click AWS Athena

Select AWS Athena.

The form requires the following information:
  • Connector Name: A descriptive name to identify this specific Athena connection in TextQL.
  • AWS Region: The AWS region where your Athena workgroup and data reside.
  • Database: The database/schema name in your catalog.
  • Workgroup: The Athena workgroup to use for queries (default: primary).
  • S3 Output Location: S3 bucket path where Athena query results will be stored.
AWS Athena Connector Form

AWS Athena Connector Form.

​
Authentication Methods

TextQL supports multiple AWS authentication methods for Athena:
  1. Access Key & Secret:
    • Access Key ID: Your AWS access key
    • Secret Access Key: Your AWS secret key
  2. IAM Role:
    • IAM Role ARN: The ARN of the role to assume
    • Session Name: A name for the assumed role session

​
S3 Data Formats

Athena supports querying various data formats stored in S3:
  • Parquet: Recommended for analytics (columnar, compressed)
  • ORC: Optimized row columnar format
  • JSON: Semi-structured data
  • CSV: Comma-separated values
  • Avro: Schema evolution support

​
Testing the Connection

After entering your credentials, click Create to establish the connection. TextQL will validate your AWS permissions and create the connector. If the connection fails, verify your IAM permissions and S3 bucket access.