DynamoDB Support (regression issue)

[leo6104]

Issue Summary

Hello, i really appreciate to redash contributors. It is awesome tools.

The one thing i found is that DynamoDB query_runner was disappear.

In v10 release, there is dynamodb_sql.py in query_runner. https://github.com/getredash/redash/tree/2589bef1f21b7c84e4ceacdf5cd2c620bdedb111/redash/query_runner

However, current latest dev version doesn't include dynamodb even though README.md describe it as supported feature.

Can we add DynamoDB in query runner again?

Steps to Reproduce

1. This is the first step
2. This is the second step, etc.

Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?

Technical details:

• Redash Version: 24.04.0-dev
• Browser/OS: Ubuntu
• How did you install Redash: docker-compose up -d (Self hosted)

[justinclift]

From rough memory, the Python driver for DynamoDB was causing issues and became unmaintained so we had to rip it out.

From the DQL README, something called PartiQL might be a workable replacement:

https://pypi.org/project/dql/#description

As of November 2020, Amazon has released PartiQL support for DynamoDB. You should investigate that
first to see if it addresses your needs.

So, someone familiar with Redash development could add PartiQL support, and then DynamoDB will likely be an option again. :smile:

[AndrewChubatiuk]

hey @leo6104 you can try to use athena datasource, it has dynamodb connector https://docs.aws.amazon.com/athena/latest/ug/connectors-dynamodb.html