profile_resource_associations

Creates, updates, deletes or gets a profile_resource_association resource or lists profile_resource_associations in a region

Overview

Name	profile_resource_associations
Type	Resource
Description	Resource Type definition for AWS::Route53Profiles::ProfileResourceAssociation
Id	aws.route53profiles.profile_resource_associations

Fields

Name	Datatype	Description
profile_id	string	The ID of the profile that you associated the resource to that is specified by ResourceArn.
id	string	Primary Identifier for Profile Resource Association
name	string	The name of an association between the Profile and resource.
resource_arn	string	The arn of the resource that you associated to the Profile.
resource_properties	string	A JSON-formatted string with key-value pairs specifying the properties of the associated resource.
resource_type	string	The type of the resource associated to the Profile.
region	string	AWS region.

Methods

Name	Accessible by	Required Params
create_resource	INSERT	ProfileId, Name, ResourceArn, region
delete_resource	DELETE	data__Identifier, region
update_resource	UPDATE	data__Identifier, data__PatchDocument, region
list_resource	SELECT	region
get_resource	SELECT	data__Identifier, region

SELECT examples

List all profile_resource_associations in a region.

SELECT
region,
id
FROM aws.route53profiles.profile_resource_associations
WHERE region = 'us-east-1';

Gets all properties from a profile_resource_association.

SELECT
region,
profile_id,
id,
name,
resource_arn,
resource_properties,
resource_type
FROM aws.route53profiles.profile_resource_associations
WHERE region = 'us-east-1' AND data__Identifier = '<Id>';

INSERT example

Use the following StackQL query and manifest file to create a new profile_resource_association resource, using stack-deploy.

Required Properties

/*+ create */
INSERT INTO aws.route53profiles.profile_resource_associations (
 ProfileId,
 Name,
 ResourceArn,
 region
)
SELECT 
'{{ ProfileId }}',
 '{{ Name }}',
 '{{ ResourceArn }}',
'{{ region }}';

All Properties

/*+ create */
INSERT INTO aws.route53profiles.profile_resource_associations (
 ProfileId,
 Name,
 ResourceArn,
 ResourceProperties,
 region
)
SELECT 
 '{{ ProfileId }}',
 '{{ Name }}',
 '{{ ResourceArn }}',
 '{{ ResourceProperties }}',
 '{{ region }}';

Manifest

version: 1
name: stack name
description: stack description
providers:
  - aws
globals:
  - name: region
    value: '{{ vars.AWS_REGION }}'
resources:
  - name: profile_resource_association
    props:
      - name: ProfileId
        value: '{{ ProfileId }}'
      - name: Name
        value: '{{ Name }}'
      - name: ResourceArn
        value: '{{ ResourceArn }}'
      - name: ResourceProperties
        value: '{{ ResourceProperties }}'

DELETE example

/*+ delete */
DELETE FROM aws.route53profiles.profile_resource_associations
WHERE data__Identifier = '<Id>'
AND region = 'us-east-1';

Permissions

To operate on the profile_resource_associations resource, the following permissions are required:

Create

route53profiles:AssociateResourceToProfile,
route53profiles:GetProfileResourceAssociation,
route53resolver:*,
route53:*

Read

route53profiles:GetProfileResourceAssociation,
route53resolver:*,
route53:*

Delete

route53profiles:DisassociateResourceFromProfile,
route53profiles:GetProfileResourceAssociation,
route53resolver:*,
route53:*

List

route53profiles:ListProfileResourceAssociations,
route53resolver:*,
route53:*

Update

route53profiles:UpdateProfileResourceAssociation,
route53profiles:GetProfileResourceAssociation,
route53resolver:*,
route53:*