Performing SQL queries on DynamoDB table using PartiQL

2022.04.20

この記事は公開されてから1年以上経過しています。情報が古い可能性がありますので、ご注意ください。

AWS

It is a secure cloud service platform that offers compute power, and database storage. content delivery, network, and other functionality to help businesses scale and grow. It is one of the first cloud vendors to start services in the year 2006. It offers all the 3 service models namely IAAS, PAAS, and SAAS. Some of the notable domains in AWS are Compute, Migration, Storage, Network and Content Delivery, Management Tools, Database, Messaging, Security and Identity Compliance, and many more.

DynamoDB

An Amazon AWS Web Services database which is a fully managed, serverless, key-value NoSQL database, has high-performance applications at any scale. It has the following benefits such as built-in security, continuous backups, automated multi-region replication, in-memory caching, and data export tools.

PartiQL

An SQL-compatible language and perform SQL operations such as select, update, delete and insert. It can easily interact with DynamoDB tables and run ad hoc services using the Management Console, Command Line, DynamoDB APIs for PartiQL, and many more. It provides availability, performance, and latency as other DyanmoDB data plane operations.

Demo

Creating a table Orders in DynamoDB Table Go to PartiQL Scanning the table on which you want to perform SQL operations

Down below are few SQL operations

1) List all the orders 2) Listing specific order using OrderID 3) Listing the orders based on State 4) Now performing scan operation with greater than 5) Inserting Data into the table 6) Now displaying the feature of UPDATE 7) Deleting a order from the table