CODEWITHSUNDEEP
amazon-s3apache-nifiamazon-athena
SunLynx
SunLynx

Reputation: 57

How to integrate Apache Nifi with Amazon Athena?

My Requirements: 1. User's will run the sql queries through Apache nifi to Amazon S3.

Is this possible to achieve Nifi integration with Amazon Athena?

Upvotes: 0

Views: 1259

Answers (2)

Joe Witt
Joe Witt

Reputation: 2172

You should be able to easily integrate Apache NiFi and Amazon Athena. The NiFi capabilities to leverage/plug-in JDBC drivers and reuse that context in many areas helps here greatly. See here for info on the JDBC drivers with Athena https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html and here for using some of NiFi's DBCP facilities https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-dbcp-service-nar/1.5.0/org.apache.nifi.dbcp.DBCPConnectionPool/index.html

Upvotes: 2

danoyoung
danoyoung

Reputation: 210

You should be able to by using a combination of an ExecuteStreamCommand and the awscli. The cli has the capabilities to issue Athena queries

Upvotes: 0

Related Questions