sqls
Creates, updates, deletes, gets or lists a sqls resource.
Overview​
| Name | sqls |
| Type | Resource |
| Id | aws.rds_data.sqls |
Fields​
The following fields are returned by SELECT queries:
SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
execute_sql | exec | region, dbClusterOrInstanceArn, awsSecretStoreArn, sqlStatements | Runs one or more SQL statements. This operation is deprecated. Please use the BatchExecuteStatement or ExecuteStatement operation. |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
region | string | AWS region (default: us-east-1) |
Lifecycle Methods​
- execute_sql
Runs one or more SQL statements. This operation is deprecated. Please use the BatchExecuteStatement or ExecuteStatement operation.
EXEC aws.rds_data.sqls.execute_sql
@region='{{ region }}' --required
@@json=
'{
"dbClusterOrInstanceArn": "{{ dbClusterOrInstanceArn }}",
"awsSecretStoreArn": "{{ awsSecretStoreArn }}",
"sqlStatements": "{{ sqlStatements }}",
"database": "{{ database }}",
"schema": "{{ schema }}"
}'
;