Support for dynamodb as datasource

[HPsisodia]

Hello, i am working on a project where i am using dynamodb local for database queries, however i am not able to connect cubejs with dynamo as datasource. Is there any community connector for dynamodb as it is not supported offically, if so i will really appreciate any help and if there isn't, are there any plans in future to provide a support?

[paveltiunov]

Hey @HPsisodia ! Thanks for posting this! Yep. It isn't on our roadmap yet however we considering adding it. As of now we'd really appreciate this contribution!

[chadfaurie]

Hi @HPsisodia DynamoDb does not support SQL queries directly, there are supposedly ways of getting around this using dql as a proxy layer, @paveltiunov not sure what this implementation would look like, seems to have a lot of moving parts

[jimjoes]

Would it be simpler if it was restricted to being the external db for pre-aggregation?

[hassankhan]

https://aws.amazon.com/about-aws/whats-new/2020/11/you-now-can-use-a-sql-compatible-query-language-to-query-insert-update-and-delete-table-data-in-amazon-dynamodb/

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[joekendal]

+1

[kleky]

+1

[markbenedict]

How would you deal with vertical row partitioning to rebuild the record, it's not exactly a uniform process.