Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] DocumentDB (MongoDB) connector can't handle Database with uppercase letters #2312

Open
tlierdotfr opened this issue Oct 4, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@tlierdotfr
Copy link

Describe the bug
There is a property that allow the connector to match Collections that have UpperCase letters in their name with appropriate GlueDB definition but it seems like that there is no such process for Database names that also may contains UpperCase letters.

To Reproduce
Steps to reproduce the behavior:

  1. Set up MongoDB and the DocumentDB connector for Athena.
  2. Configure the Glue database "mydatabase" to match existing MongoDB database "myDatabase"
  3. Set the URI parameter to "docdb-metadata-flag"
  4. Configure the Glue table "data" with "docdb-metadata-flag" set to true and sourceTable property set to "data"
  5. In Athena, query the collection either using : select * from mydatabase.data or select * from myDatabase.data
  6. See no results at all

Expected behavior
The query should display results accordingly to table content.

Screenshots / Exceptions / Errors
Query without any rows :
image

Using SELECT * FROM TABLE(system.query( ... )) seems to work but unfortunately this querying method is not compatible with Athena Quicksight DataSource.
image

Connector Details (please complete the following information):

  • Version: 2024.25.1
  • Name aws-athena-query-federation for DocumentDB

Additional context
I use MongoDB 4.4 data source and not DocumentDB for this use case.

@tlierdotfr tlierdotfr added the bug Something isn't working label Oct 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant