resource_policies

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

Overview

Name	resource_policies
Type	Resource
Id	aws.redshift.resource_policies

Fields

The following fields are returned by SELECT queries:

get_resource_policy

Name	Datatype	Description
policy	string	The content of a resource policy.
resource_arn	string	The resources that a policy is attached to.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_resource_policy	select	ResourceArn, region		Get the resource policy for a specified resource.
put_resource_policy	replace	ResourceArn, region	Policy	Updates the resource policy for a specified resource.
delete_resource_policy	delete	ResourceArn, region		Deletes the resource policy for a specified resource.

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
ResourceArn	string	The Amazon Resource Name (ARN) of the resource of which its resource policy is deleted.
region	string	AWS region (default: us-east-1)
Policy	string	The content of the resource policy being updated.

SELECT examples

get_resource_policy

Get the resource policy for a specified resource.

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

REPLACE examples

put_resource_policy

Updates the resource policy for a specified resource.

REPLACE aws.redshift.resource_policies
SET 
-- No updatable properties
WHERE 
ResourceArn = '{{ ResourceArn }}' --required
AND region = '{{ region }}' --required
AND Policy = '{{ Policy}}'
RETURNING
policy,
resource_arn;

DELETE examples

delete_resource_policy

Deletes the resource policy for a specified resource.

DELETE FROM aws.redshift.resource_policies
WHERE ResourceArn = '{{ ResourceArn }}' --required
AND region = '{{ region }}' --required
;