hasura / hasura/graphql-engine

AWS Athena Connector - Table names with dot

Open
#9,901 1 comment 0 reactions 0 assignees View on GitHub
k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: v2.33.4-cloud.1
CLI Version (for CLI related issue):

### Environment

Cloud

### What is the current behaviour?

Tablenames including a dot are not parsed properly which leads to a failing graphql query.

We do have a dort because we are using a certain schema in Postgres.

### What is the expected behaviour?

Tablenames including a dort are parsed properly and don't lead the graphql query to fail.

### How to reproduce the issue?

I guess it is a bit tricky to reproduce it. Please mention if you have an easier way:

1. Use https://github.com/CloudbreakUS/simple-database-archival-solution with PostgreSQL
2. Connect Hasura to AWS Glue Database with the Athena connector
3. Track a table and query data

### Screenshots or Screencast

AthenaTableBug

### Please provide any traces or logs that could help here.

### Any possible solutions/workarounds you're aware of?

Don't use tablenames with a dot inside. I could change the code at https://github.com/CloudbreakUS/simple-database-archival-solution to not use a dot for the tablename and with that it works.

### Keywords

* AWS Athena

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the issue with the linked simple-database-archival-solution, PostgreSQL, AWS Glue Database, and the Athena connector. Track a table whose name contains a dot and query it through GraphQL; done means the table name is parsed correctly and the query succeeds without requiring a workaround.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, postgresql
Domain
api, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.