awslabs / aws-athena-query-federation

The Amazon Athena Query Federation SDK allows you to customize Amazon Athena with your own data sources and code.
Apache License 2.0
557 stars 293 forks source link

[FEATURE] Add OpenCypher Support to Neptune Connector #2118

Open mhavey opened 3 months ago

mhavey commented 3 months ago

Is your feature request related to a problem? If yes, please describe. Current Neptune connector does not allow me to make OpenCypher custom or passthrough queries. Additionally, current connector does not support Neptune Analytics, which currently supports only OpenCypher as query language.

Describe the solution you'd like Neptune connector currently supports RDF and Property graph types. Property graph uses Gremlin to talk to Neptune. Neptune supports both Gremlin and OpenCypher. Add support in Connector for OpenCypher. Furthermore, allow connector to be configured to use either Neptune database or Neptune Analytics. Add graph-identifier parameter for connectivity to NA.

Describe alternatives you've considered Gremlin is an alternative on Neptune database, not Neptune Analytics

Additional context In addition to basic node/edge table support, passthrough support is also desired.

macohen commented 3 months ago

@mhavey are you willing to work on this? Are you able to post any error message you see when executing a passthrough query with OpenCypher?

cc:@AbdulR3hman

mhavey commented 3 months ago

Yes, will discuss with Neptune dev team.

fatima-kscope commented 1 week ago

@mhavey is this feature being taken up?

mhavey commented 1 week ago

I discussed with the dev team. It is a good feature, but it is not highest priority currently. I recommend keeping open.