Skip to main content

sqls

Creates, updates, deletes, gets or lists a sqls resource.

Overview​

Namesqls
TypeResource
Idaws.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:

NameAccessible byRequired ParamsOptional ParamsDescription
execute_sqlexecregion, dbClusterOrInstanceArn, awsSecretStoreArn, sqlStatementsRuns 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.

NameDatatypeDescription
regionstringAWS region (default: us-east-1)

Lifecycle Methods​

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 }}"
}'
;