Amazon Athena Connections

Amazon Athena is a service that enables a data analyst to perform interactive queries in the AWS public cloud on data stored in Amazon Simple Storage Service (S3)For more information, seehttps://aws.amazon.com/athena/.

Suggerimento

This connection is in early preview. It is read-only and available only in SaaS product editions. For more information on early previews, see Early Preview Connection Types.

Unified ODBC connector available

Alteryx One also provides a new Amazon Athena (ODBC) connector built on the Unified connector framework. For configuration instructions, supported capabilities, and authentication information, see Amazon Athena (ODBC) Connections.Amazon Athena (ODBC) Connections

This legacy connector is deprecated

This page describes the legacy Amazon Athena connector in Designer Cloud. This connector was deprecated on October 6, 2026 and will reach End of Support on October 6, 2027.

Use the new Amazon Athena (ODBC) connector for new connections. Existing connections and workflows are not migrated automatically. Recreate the applicable connections with the new connector and update the affected workflows before the End of Support date.

Limitations and Requirements

If a table cannot be imported due to an issue with a specific column, use a custom SQL statement with that column in the WHERE clause to filter and ingest the data. For more information, please consult the CData driver documentation for the specific table. For more information on using custom SQL, see Create Dataset with SQL.
For filtering date columns, this connection type supports a set of date-literal functions. You can use these to reduce the volume of data extracted from the database using a custom SQL query. For more information, see the pg_dateliteralfunctions.htm page in the driver documentation for this connection type.
Supports authentication using AWS key and secret.

Create Connection

via Cloud Portal

When you create the connection, please review the following properties and specify them accordingly:

Connection Property	Description
AWS Region	The hosting region for your Amazon Web Services resources. For more information, seehttps://cdn.cdata.com/help/FKG/jdbc/RSBAmazonAthena_p_AWSRegion.htm
S3 Staging Directory	Specifies the location in your S3 bucket where Amazon Athena can store the results of a query.
Database	The name of the Amazon Athena database.
Connect String Options	The following are the connect string options passed to the JDBC driver by default: Timeout=0;CleanQueryResults=true; `Timeout` - This value sets the connection timeout in seconds. Setting this value to `0` disables timeouts. `CleanQueryResults` - The results of every query that runs on Amazon Athena is stored in the S3 staging directory. Setting`CleanQueryResults`to`true`clears the query results from the S3 staging directory after ingestion.
Access Key ID	AWS account access key. This value is accessible from your AWS security credentials page.
Secret access key	AWS account secret key. This value is accessible from your AWS security credentials page.
Default Column Data Type Inference	Leave this value as `Enabled`.

For more information, see the driver documentation https://cdn.cdata.com/help/FKK/jdbc/ .

via API

Depending on your product edition, you can create connections of this type. Key information:

"vendor": "amazon_athena",
"vendorName": "Amazon Athena",
"type": "jdbc"

For more information, see

Coming soon.

Data Type Conversions

For more information, see the driver documentation https://cdn.cdata.com/help/FKG/jdbc/ .

In questa sezione: