Holistics Docs - End-to-End Business Intelligence Platform

Holistics Documentation

Welcome to the Holistics Documentation page. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started

Amazon AWS Athena Setup

The following steps will help you setup connection to your Athena Instance. Please ensure that you have an Amazon IAM account, and an S3 bucket.

You can follow this video for a walkthrough of the steps, or skip ahead to follow the instructions below.

Step 1: Create an Holistics User in Amazon IAM Console

Add a user with 'Programmatic Access' in Amazon IAM Console.

Allow this user full access to Athena API: AmazonAthenaFullAccess.

Or a custom policy with full access to Athena, and List, Read, Write to the source S3 bucket.

Step 2: Add AWS Athena Data Source

Create an Athena database using AWS Athena Console.

Visit Data Source page and add a new data source. Select AWS Athena data source type, then fill in the form:

  • Region: AWS region hosting Athena database, source file S3 buckets, and query result S3 bucket.
  • Database Name: Specify the default database. Other databases can still be accessed, but Holistics treats this database as the default database.
  • Access Key ID and Secret Access Key are from the Amazon account you created in Step 1.
  • Database Name: the Athena database you've just set up. All queries are sent to this database.
  • Result Bucket: all Athena query results are stored in this bucket. The current Amazon account should be able to access this bucket. Please see AWS Athena docs for more details.
  • Storage Bucket URL: This is the bucket to store your imported data and files.

Step 3: Setup your Athena Instance for Querying

First, you need to create Athena table to be used as schema-on-read during query execution (Please refer to AWS Athena docs for more details). Remember to enable Non-select Queries.

Then you can build report, view results, and make charts.

Updated about a month ago

Amazon AWS Athena Setup


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.