resource_policies

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

Overview

Name	resource_policies
Type	Resource
Id	aws.redshift_serverless.resource_policies

Fields

The following fields are returned by SELECT queries:

get_resource_policy

Name	Datatype	Description
policy	string	The resource policy.
resource_arn	string	The Amazon Resource Name (ARN) of the policy.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_resource_policy	select	region		Returns a resource policy.
put_resource_policy	replace	region, policy, resourceArn		Creates or updates a resource policy. Currently, you can use policies to share snapshots across Amazon Web Services accounts.
delete_resource_policy	delete	region		Deletes the specified resource policy.

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)

SELECT examples

get_resource_policy

Returns a resource policy.

SELECT
policy,
resource_arn
FROM aws.redshift_serverless.resource_policies
WHERE region = '{{ region }}' -- required
;

REPLACE examples

put_resource_policy

Creates or updates a resource policy. Currently, you can use policies to share snapshots across Amazon Web Services accounts.

REPLACE aws.redshift_serverless.resource_policies
SET 
policy = '{{ policy }}',
resourceArn = '{{ resourceArn }}'
WHERE 
region = '{{ region }}' --required
AND policy = '{{ policy }}' --required
AND resourceArn = '{{ resourceArn }}' --required
RETURNING
resource_policy;

DELETE examples

delete_resource_policy

Deletes the specified resource policy.

DELETE FROM aws.redshift_serverless.resource_policies
WHERE region = '{{ region }}' --required
;