/dynamodb-virtual-schema

Virtual Schema for accessing Amazon AWS DynamoDB through Exasol

Primary LanguageJavaMIT LicenseMIT

Virtual Schema for AWS DynamoDB

Build Status

Quality Gate Status

Security Rating Reliability Rating Maintainability Rating Technical Debt

Code Smells Coverage Duplicated Lines (%) Lines of Code

Overview

This adapter allows you to access document data that is stored in a Amazon's DynamoDB from inside of the Exasol analytical database. It abstracts over the different interfaces so that you can access the document data just like any regular Exasol table.

Features

  • Read access to data stored in DynamoDB
  • Maps unstructured document data to Exasol tables that you can access using regular SQL statements
  • Pushes down queries to the remote source
  • Distributes the data loading over the whole Exasol Cluster, what makes queries more than six times faster compared to using a JDBC adapter
  • Flexible definition of the schema mapping using the Exasol Document Mapping Language (EDML)

Limitations

  • The adapter does not support comparisons between two columns.

Information for Users

Information for Developers