Working with Athena Connection
Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace  Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
Kyvos supports Amazon Athena Service to run interactive ad hoc SQL queries against data on Amazon S3, without having to manage any infrastructure or cluster. Athena is an interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL. Athena scales automatically, running queries in parallel, so results are fast, even with large datasets and complex queries.
Note
You can create multiple Athena connections for raw data querying. The connections are available on the Semantic model designer page, where you can select the connection to be used for a particular semantic model.Â
See the Working with non-materialized or raw data semantic models section for more details.Â
Prerequisites
The permissions required to run Athena queries include the following:Â Â
Amazon S3 locations where the underlying data to query is stored.Â
Metadata and resources that you store in the AWS Glue Data Catalog, such as databases and tablesÂ
Athena API actionsÂ
To set up or view the AthenaSQL connection, perform the following steps.
From the Toolbox, click Setup, then Connections.
From the Actions menu ( ⋮ ) click Add Connection.
Enter a Name or select it from the Connection list.
After you finish configuring the settings using the table shown below, click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.Â
Parameter/Field | Comments/Description |
---|---|
Name | Enter a unique name for the connection. |
Category | Select the SQL Engine option. |
Provider | Select the Athena option. |
Catalog | Enter the data source registered in Athena. |
Workgroup | Enter the Athena Workgroup to be used for querying. |
S3 Location Type | Select the type of S3 location from any of the following:
NOTE: For Workgroup defined and User defined options, Athena automatically deletes the query result after 45 days. |
S3 Location | Provide the location of the S3 bucket to be used for reading data. |
Authentication Type | By default, the IAM - Instance Profile Credentials option is selected. |
URL | Type the URL in jdbc:awsathena://athena.<Region>.amazonaws.com:443 format. |
Use as source | By default, the checkbox is selected as this connection can only be used to read data (creating registered datasets) on which the semantic model will be created. |
Is Default SQL Engine | To enable the connection for raw data, select the checkbox to set this connection to run the default SQL engine. |
Properties | Click Properties to view or set properties. |
Â
Copyright Kyvos, Inc. All rights reserved.