Using AWS Console CLI

Macrometa GDN can be used as the data store for apps written for AWS DynamoDB. Switch to using GDN by just changing the connection URL, accessKey and secretKey. You can continue using aws dynamodb sdk and cli you are familiar with.

note

Macrometa GDN provides aws dynamo db global tables as the default option.

This enables you to deliver low-latency data access to your users no matter where they are located. GDN performs all of the necessary tasks to create identical tables in all the regions around the globe and propagate ongoing data changes to all of them.

Similarly GDN provides better data consistency guarantees i.e., strong consistency within a region and strong eventual consistency across regions utilizing CRDTs and partially ordered logs.

Prerequisites

1. Create an API Key

   • Login to your tenant account on https://play.paas.macrometa.io
   • Create an API key via GUI/REST API. Make a copy of the key.
   tip

   Following api key is created under `demo@macrometa.io/_system` on https://play.paas.macrometa.io with `rw` permissions.
   ```bash
       demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
   ```

2. Download & Install AWS Console CLI

   • URL: https://aws.amazon.com/cli/
   • Mac OS: https://awscli.amazonaws.com/AWSCLIV2.pkg
   note

   $ aws --version
   
   aws-cli/2.0.34 Python/3.7.4 Darwin/19.5.0 botocore/2.0.0dev38

3. Configure cli using aws configure command.

       (base) ~/demos$ aws configure
       AWS Access Key ID [****************0000]: apikey demo.demok1.1a1aad0f4b000ca4d2d3bdb505298cbb9467b65526b0f79364e61e5f00000000
       AWS Secret Access Key [****************0000]: 
       Default region name [us-west-1]: 
       Default output format [None]: 
   note

   1. For API Keys, put `apikey` as prefix. See above example.
   2. For JWT Tokens, put `bearer` as prefix.

Create Global Table

In this step, you create a Music global table in GDN. The table has the following details:

• Partition key — Artist
• Sort key — SongTitle

    aws dynamodb create-table \
        --table-name Music \
        --attribute-definitions \
            AttributeName=Artist,AttributeType=S \
            AttributeName=SongTitle,AttributeType=S \
        --key-schema \
            AttributeName=Artist,KeyType=HASH \
            AttributeName=SongTitle,KeyType=RANGE \
        --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Create Local Table

In this step, you create a Music local table in GDN. The table has the following details:

• Partition key — Artist
• Sort key — SongTitle

    aws dynamodb create-table \
        --table-name Music \
        --attribute-definitions \
            AttributeName=Artist,AttributeType=S \
            AttributeName=SongTitle,AttributeType=S \
        --key-schema \
            AttributeName=Artist,KeyType=HASH \
            AttributeName=SongTitle,KeyType=RANGE \
        --provisioned-throughput ReadCapacityUnits=5,WriteCapacityUnits=5 \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo \
        --tags Key=Local,Value=True

note

Local tables are allowed only if flag dynamo_local_tables=true for the tenant.

List Global Tables

The following AWS CLI example lists available global tables in your GDN.

    aws dynamodb list-global-tables --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

List Local Tables

The following AWS CLI example lists available local tables in your GDN.

    aws dynamodb list-tables --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

note

list-tables will return local tables when dynamo_local_tables flag is true for the tenant.

Put Items

The following AWS CLI example creates two new items in the Music global table using put-item.

    aws dynamodb put-item \
        --table-name Music \
        --item '{"Artist": {"S": "Obscure Indie Band"}, "SongTitle": {"S": "Call Me Today"}}' \
        --condition-expression "attribute_not_exists(Artist)" \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

    aws dynamodb put-item \
        --table-name Music \
        --item '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
        --condition-expression "attribute_not_exists(Artist)" \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Get Item

The following AWS CLI example reads an item from the Music global table using get-item.

    aws dynamodb get-item \
        --table-name Music \
        --key '{ "Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}'
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Batch Get Items

The following AWS CLI example reads multiple items from the Music global table using batch-get-item.

    aws dynamodb batch-get-item \
        --request-items '{"Music": {"Keys": [{"Artist": {"S": "Obscure Indie Band"},"SongTitle": {"S": "Call Me Today"}},{"Artist": {"S": "Luke Combs"},"SongTitle": {"S": "Tequila"}}],"ProjectionExpression":"Artist"}}' \
        --return-consumed-capacity TOTAL \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Batch Write Items

The following AWS CLI example writes multiple items to the Music global table using batch-write-item.

   aws dynamodb batch-write-item \
     --request-items '{"Music": [{"PutRequest": {"Item": {"Artist": {"S": "TestName1"},"SongTitle": {"S": "The Best1"}}}},{"PutRequest": {"Item": {"Artist": {"S": "TestName2"},"SongTitle": {"S": "The Best2"}}}}]}' \
     --return-consumed-capacity INDEXES \
     --return-item-collection-metrics SIZE \
     --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Scan Items

The following AWS CLI example scans Music global table using scan.

    aws dynamodb scan \
       --table-name Music \
       --filter-expression "Artist = :a" \
       --projection-expression "#ST, #AT" \
       --expression-attribute-names '{"#ST": "SongTitle","#AT":"Artist"}' \
       --expression-attribute-values '{":a": {"S": "TestName1"}}' \
       --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Query Items

The following AWS CLI example queries an item in the Music global table using query.

Query All Items:

    aws dynamodb query \
        --table-name Music \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Query By Artist Name:

    aws dynamodb query \
        --table-name Music \
        --key-condition-expression "Artist == :name" \
        --expression-attribute-values  '{":name":{"S":"Luke Combs"}}' \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Query By complex conditions:

    aws dynamodb query \
        --table-name Music \
        --key-condition-expression "Artist == :n1 OR begins_with(Artist, :n2)" \
        --expression-attribute-values  '{":n1":{"S":"Luke Combs"}, ":n2":{"S":"Obscure"}}' \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo  

    aws dynamodb query \
        --table-name Music \
        --key-condition-expression "Artist == :n1 OR begins_with(Artist, :n2)" \
        --filter-expression "#a <> :n1" \
        --expression-attribute-names '{"#a": "Artist"}' \
        --expression-attribute-values  '{":n1":{"S":"Luke Combs"}, ":n2":{"S":"Obscure"}}' \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Count Items

The following AWS CLI example counts items in the Music global table using query.

    aws dynamodb query \
        --table-name Music \
        --select COUNT \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Update Item

The following AWS CLI example updates an item in the Music global table using update-item.

    aws dynamodb update-item \
        --table-name Music \
        --key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Tequila"}}' \
        --update-expression "SET Year = :y, SongTitle = :t" \
        --expression-attribute-values  '{":y":{"N":"2020"}, ":t":{"S":"Happy Day"}}' \
        --return-values ALL_NEW \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Delete Item

The following AWS CLI example deletes item in the Music global table using delete-item.

    aws dynamodb delete-item \
        --table-name Music \
        --key '{"Artist": {"S": "Luke Combs"}, "SongTitle": {"S": "Happy Day"}}' \
        --return-values ALL_OLD \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo

Delete Table

The following AWS CLI example deletes the Music global table using delete-table.

    aws dynamodb delete-table \
        --table-name Music \
        --endpoint-url https://api-play.paas.macrometa.io/_api/dynamo