Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora Serverless DB cluster. To run these statements, you work with the Data Service API. AWS RDS DataService
You can run bulk update and insert operations for multiple records using a DML statement with different parameter sets. Bulk operations can provide a significant performance improvement over individual insert and update operations.
The Amazon RDS Data Service API contains several data types that various actions use.
Below are the cmdlets which are available with AWS RDS DataService
CmdletName | ServiceOperation |
Confirm-RDSDTransaction | CommitTransaction |
Invoke-RDSDSqlStatement | ExecuteSql |
Invoke-RDSDStatement | ExecuteStatement |
Invoke-RDSDStatementBatch | BatchExecuteStatement |
Reset-RDSDTransaction | RollbackTransaction |
Start-RDSDTransaction | BeginTransaction |
You can also check other AWS Services, and each services cmdlets we are providing.