Tableau Connector for Amazon Athena

Build 21.0.7929

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.


PropertyDescription
BatchSizeThe maximum size of each batch operation to submit.
CleanQueryResultsAmazon Athena produces cache files with every query, in the folder specified in S3StagingDirectory . CleanQueryResults specifies whether these files should be deleted once the connection is closed.
ConnectionLifeTimeThe maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.
ConnectOnOpenThis property species whether to connect to the Amazon Athena when the connection is opened.
EnableFIPSModeA boolean indicating if FIPS URLs should be enabled.
IncludeTableTypesIf set to true, the provider will query for the types of individual tables.
MaximumColumnSizeThe maximum column size.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
MetadataDiscoveryMethodAPI to use to retrieve the metadata for Amazon Athena.
OtherThese hidden properties are used only in specific use cases.
PageSizeThe number of results to return per page of data retrieved from Amazon Athena.
PollingIntervalThis determines the polling interval in milliseconds to check whether the result is ready to be retrieved.
PoolIdleTimeoutThe allowed idle time for a connection before it is closed.
PoolMaxSizeThe maximum connections in the pool.
PoolMinSizeThe minimum number of connections in the pool.
PoolWaitTimeThe max seconds to wait for an available connection.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
QueryCachingLevelModifies the usage of query results stored in S3StagingDirectory . Cached queries will not be scanned again by Amazon Athena until the amount of seconds specified in QueryTolerance has passed.
QueryPassthroughThis option passes the query to the Amazon Athena server as is.
QueryTimeoutThe timeout in seconds for requests issued by the provider to download large result sets.
QueryToleranceSpecifies the amount of time in seconds queries cache for if QueryCachingLevel is not set to None.
RTKThe runtime key used for licensing.
ShowS3FilepathWhether or not to expose the _S3Path column for the Amazon Athena tables.
SkipHeaderLineCountSpecifies the number of header rows to skip for SELECT queries.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseConnectionPoolingThis property enables connection pooling.
WorkgroupWork group of the executed queries.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7929