Skip to content

Virtual Schema for accessing Amazon AWS DynamoDB through Exasol

License

Notifications You must be signed in to change notification settings

exasol/dynamodb-virtual-schema

Repository files navigation

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