Hub
NodeNode / Source

Amazon Athena Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to Amazon Athena using the native Amazon Athena JDBC driver. You need to provide the server's hostname (or IP address) and the port. Login credentials are taken from the connected Amazon Authentication connection.

Notice: This node only supports the built-in driver that works together with the Amazon Authentication input information. Please use the DB Connector node for all other drivers.

For more information visit Amazon Athena and also the AWS Forums .

Node details

Input ports
  1. Type: AWS Comprehend Connection
    Amazon Authentication
    Amazon Authentication information
Output ports
  1. Type: DB Session
    Amazon Athena Connection
    Amazon Athena connection

Extension

The Amazon Athena Connector node is part of this extension:

Related workflows & nodes

  1. AWS_Auth_S3_connection
    mraraman > Public > AWS_Auth_S3_connection
  2. LOCAL_TO_AWS_S3
    naveennagaraj66 > Public > LOCAL_TO_AWS_S3
  3. AWS_Auth_S3_connection
    mraraman > Public > IPF > AWS_Auth_S3_connection
  4. AWS_Auth_S3_connection
    alamisrar > Public > IPF > AWS_Auth_S3_connection
  5. Connecting to Amazon EMR
    Amazon AWS EMR
    +4
    This workflow demonstrates how to create a Spark context via Apache Livy and execute a si…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 08_Connecting_to_Amazon_EMR
  6. demo-dqa-rules1
    mraraman > Public > demo-dqa-rules1
  7. demo-dqa-rules1
    mraraman > Public > IPF > demo-dqa-rules1
  8. demo-dqa-rules1
    alamisrar > Public > IPF > demo-dqa-rules1
  9. Google BigQuery and Amazon Athena - Will They Blend?
    BigQuery Athena GWAS
    In this workflow, we combine data from Genome Wide Association studies in Google BigQuery…
    knime > Examples > 01_Data_Access > 02_Databases > 12_Google_BigQuery_and_Amazon_Athena_will_they_blend
  10. Google BigQuery and Amazon Athena - Will They Blend?
    BigQuery Athena GWAS
    In this workflow, we combine data from Genome Wide Association studies in Google BigQuery…
    marcelw > Public > Example_workflows_cleaned_up > 01_Data_Access > 02_Databases > 12_Google_BigQuery_and_Amazon_Athena_will_they_blend