dynamodb-tracking-tables-billing-mode

--dynamodb-tracking-tables-billing-mode is a global parameter for the Liquibase DynamoDB Pro extension. It specifies the initial billing mode for Liquibase tracking tables: DATABASECHANGELOG and DATABASECHANGELOGLOCK. This controls how you pay for database read/write operations and capacity. Valid values are PROVISIONED and PAY_PER_REQUEST. The default value is PAY_PER_REQUEST.

Note: If you want to change the billing mode of the tracking tables after you create them, you must instead use the updateDynamoTable Change Type.

Uses

Amazon DynamoDB has two pricing models for the number of read and write operations you perform on tables in your database every second:

• On-demand (PAY_PER_REQUEST): only pay for requests you actually make
• Provisioned (PROVISIONED): you pay for a specific maximum number of requests per second

For more information, see Read/write capacity mode.

Liquibase automatically creates internal tracking tables like the DBCL, DBCLL, and DBCLH in your database. It uses these to run commands like update and rollback and record changes to the database's state.

The --dynamodb-tracking-tables-billing-mode parameter lets you define which billing mode DynamoDB uses for read/write operations Liquibase makes to those tracking tables:

• If you can't estimate your database's expected load on the Liquibase tracking tables in advance, use PAY_PER_REQUEST. This way, you won't reach capacity.
• If you can estimate your database's expected load on the Liquibase tracking tables in advance, use PROVISIONED. Then set custom capacity values for the following parameters:
  • --dynamodb-tracking-tables-provisioned-throughput-read-capacity-units
  • --dynamodb-tracking-tables-provisioned-throughput-write-capacity-units.

Note: If you set a capacity value too low and then exceed it, DynamoDB will throttle your requests.

Syntax

You can set this parameter in the following ways:

liquibase.dynamodb.trackingTables.billingMode: <string>

stages:
  Default:
    actions:
      - type: liquibase
        command: update
        globalArgs: { dynamodb-tracking-tables-billing-mode: "<string>" }

liquibase
 --dynamodb-tracking-tables-billing-mode=<string> update
 --changelog-file=example-changelog.xml

JAVA_OPTS=-Dliquibase.dynamodb.trackingTables.billingMode=<string>

LIQUIBASE_DYNAMODB_TRACKING_TABLES_BILLING_MODE=<string>

For more information, see Working with Command Parameters.

Related links

• BillingModeSummary
• Read/write capacity mode