Amazon Athena

Features

Work with Amazon Athena tables straight from Quix, execute multiple queries in parallel, explore the db tree, visualize and download the results into csv.

Setup

1. Create a new IAM Policy

Create a new IAM policy to allow access to your bucket

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "s3:GetObject",
                "s3:PutObject"
            ],
            "Resource": [
                "arn:aws:s3:::your-bucket-name/*"
            ]
        },
        {
            "Effect": "Allow",
            "Action": [
                "s3:GetBucketLocation",
                "s3:ListBucket"
            ],
            "Resource": [
                "arn:aws:s3:::your-bucket-name"
            ]
        }
    ]
}

2. Create a new IAM user

Create a new user with Programmatic Access. Attach security policy AmazonAthenaFullAccess along with policy created in step 1.

3. Pick a new name for your athena note and update .env

Add/update following properties to .env file to configure your new note

Variables	Meaning	Example
MODULES	list of registered notes	foo,boo
MODULES_FOO_ENGINE	note type	athena
MODULES_FOO_OUTPUT	s3 bucket for results	s3://some-bucket-id/
MODULES_FOO_REGION	aws region	us-east-1
MODULES_FOO_DATABASE	default database	default
MODULES_FOO_AWS_ACCESS_KEY_ID	aws access key
MODULES_FOO_AWS_SECRET_KEY	awe secret key

Example of possible configuration that will create note type named foo :

MODULES_FOO_ENGINE=athena
MODULES_FOO_OUTPUT=s3://some-bucket-id/
MODULES_FOO_REGION=us-east-1
MODULES_FOO_DATABASE=default
MODULES_FOO_AWS_ACCESS_KEY_ID=123
MODULES_FOO_AWS_SECRET_KEY=abc

Troubleshooting