AmazonAthenaConnector

Input

This transformer accepts any feature.

Output

The output port will contain attributes set in the Exposed Attributes parameter, which correspond to the columns from the ran query.

Initiator

The incoming feature is output through this port.

Features that cause the operation to fail are output through this port. An fme_rejection_code attribute, having the value ERROR_DURING_PROCESSING, will be added, along with a more descriptive fme_rejection_message attribute which contains more specific details as to the reason for the failure.

Note If a feature comes in to the AmazonAthenaConnector already having a value for fme_rejection_code, this value will be removed.

Rejected Feature Handling: can be set to either terminate the translation or continue running when it encounters a rejected feature. This setting is available both as a default FME option and as a workspace parameter.

Authentication

Credential Source	Credentials can be used from different sources. Using a web connection integrates best with FME, but in some cases, you may wish to use one of the other sources. Web Connection - use an Amazon Web Services web connection stored in the FME web connections database Embedded - embed an account name and access key as parameters in the transformer System - use credentials already configured on the system, in the environment variables AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY
Account	Available when the credential source is Web Connection. To create an Amazon Web Services connection, click the 'Account' drop-down box and select 'Add Web Connection...'. The connection can then be managed via Tools -> FME Options... -> Web Connections.
Region	The AWS Region in which the S3 dataset resides. Overrides the region set in the web connection if specified.
AWS CA Bundle	The AWS CA Bundle specifies the path to a certificate bundle to use for certificate validation. If set, this has precedence over the value of the AWS_CA_BUNDLE environment variable.
Embedded Credentials	Available when the credential source is Embedded. An access id and secret key can be specified directly in the transformer instead of in a web connection.

Run Query

Use Named Query	If Yes, use a named query, otherwise specify a query.
Named Query	A named query to run.
Query	The SQL query to run.
Query Timeout	Seconds until a running query is cancelled. The default and maximum is 30 minutes (1800 seconds).

S3 Result Location

The bucket and path to save the results of the query. Athena generates a metadata file and a CSV file of the results.

This should not be the same location that the Athena table source data lives or the results of subsequent queries will be contaminated by the staging files.

Note This output is not deleted when the query completes. You should either use a location with default Object Expiration, or manually delete the output.

Save Query

If checked, the query will be saved for use later.

Database	The database the saved query.
Title	The title of the saved query.
Description	The descriptive text of the saved query.

Save Table

If checked, save the results to a table.

Database	The database to save the table.
Table Name	The name of the table.
Description	The description of the table.
Output Bucket	The bucket to store the table data.
Output Path	The path to store the table data. This location must be empty.
Format	The format to store the table data. Parquet and ORC are recommended.

Exposed Attributes

The list of attributes to output. These should be the column names of the query.

How to Set Parameter Values

Defining Values

There are several ways to define a value for use in a Transformer. The simplest is to simply type in a value or string, which can include functions of various types such as attribute references, math and string functions, and workspace parameters.

Using the Text Editor

The Text Editor provides a convenient way to construct text strings (including regular expressions) from various data sources, such as attributes, parameters, and constants, where the result is used directly inside a parameter.

Text Editor

Using the Arithmetic Editor

The Arithmetic Editor provides a convenient way to construct math expressions from various data sources, such as attributes, parameters, and feature functions, where the result is used directly inside a parameter.

Arithmetic Editor

Conditional Values

Set values depending on one or more test conditions that either pass or fail.

Parameter Condition Definition Dialog

Content

Expressions and strings can include a number of functions, characters, parameters, and more.

When setting values - whether entered directly in a parameter or constructed using one of the editors - strings and expressions containing String, Math, Date/Time or FME Feature Functions will have those functions evaluated. Therefore, the names of these functions (in the form @<function_name>) should not be used as literal string values.

Content Types

String Functions	These functions manipulate and format strings.
Special Characters	A set of control characters is available in the Text Editor.
Math Functions	Math functions are available in both editors.
Date/Time Functions	Date and time functions are available in the Text Editor.
Math Operators	These operators are available in the Arithmetic Editor.
FME Feature Functions	These return primarily feature-specific values.
FME Parameters	FME and workspace-specific parameters may be used.
Creating and Modifying User Parameters	Create your own editable parameters.

Dialog Options - Tables

Table Tools

Transformers with table-style parameters have additional tools for populating and manipulating values.

Row Reordering

Enabled once you have clicked on a row item. Choices include:

Add a row
Remove a row
Move current row up one
Move current row down one
Move current row to top
Move current row to bottom

Cut, Copy, and Paste

Enabled once you have clicked on a row item. Choices include:

Cut a row - delete and copy to clipboard
Copy a row to the clipboard
Paste a row from the clipboard

Cut, copy, and paste may be used within a transformer, or between transformers.

Filter

Start typing a string, and the matrix will only display rows matching those characters. Searches all columns. This only affects the display of attributes within the transformer - it does not alter which attributes are output.

Import

Import populates the table with a set of new attributes read from a dataset. Specific application varies between transformers.

Reset/Refresh

Generally resets the table to its initial state, and may provide additional options to remove invalid entries. Behavior varies between transformers.

Note: Not all tools are available in all transformers.

Processing Behavior	Feature-Based
Feature Holding	No
Dependencies	Amazon Web Services account
Aliases
History	Released FME 2019.2

AmazonAthenaConnector

How does it work?

Costs

Configuration

Input Ports

Output Ports

Parameters

Editing Transformer Parameters

Reference

FME Community