CmdID

CmdID / aws / aws rds-data

aws rds-data batch-execute-statement

Runs a batch SQL statement over an array of data. AWS CLI reference

1 example 7 options Its page in the AWS CLI reference

Opens CmdID with your command. It is read in your browser and sent nowhere.

Examples

from aws-cli, each command read by CmdID

To execute a batch SQL statement

The following batch-execute-statement example executes a batch SQL statement over an array of data with a parameter set.

aws rds-data batch-execute-statement --resource-arn "arn:aws:rds:us-west-2:123456789012:cluster:mydbcluster" --database "mydb" --secret-arn "arn:aws:secretsmanager:us-west-2:123456789012:secret:mysecret" --sql "insert into mytable values (:id, :val)" --parameter-sets "[[{\"name\": \"id\", \"value\": {\"longValue\": 1}},{\"name\": \"val\", \"value\": {\"stringValue\": \"ValueOne\"}}],Identify
--resource-arnThe Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.
--databaseThe name of the database.
--secret-arnThe ARN of the secret that enables access to the DB cluster.
--sqlThe SQL statement to run.
--parameter-setsThe parameter set for the batch operation.
[{\"name\": \"id\", \"value\": {\"longValue\": 2}},{\"name\": \"val\", \"value\": {\"stringValue\": \"ValueTwo\"}}],
[{\"name\": \"id\", \"value\": {\"longValue\": 3}},{\"name\": \"val\", \"value\": {\"stringValue\": \"ValueThree\"}}]]"

This command produces no output.

For more information, see Using the Data API for Aurora Serverless in the Amazon RDS User Guide.

Options

7 in the AWS CLI reference
--databaseThe name of the database.
--parameter-setsThe parameter set for the batch operation.
--resource-arnThe Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.
--schemaThe name of the database schema.
--secret-arnThe ARN of the secret that enables access to the DB cluster.
--sqlThe SQL statement to run.
--transaction-idThe identifier of a transaction that was started by using the BeginTransaction operation.