Skip to main content

profiles

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

Overview

Nameprofiles
TypeResource
Idaws.route53profiles.profiles

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
arnstringThe Amazon Resource Name (ARN) of the Profile.
client_tokenstringThe ClientToken value that was assigned when the Profile was created.
creation_timestring (date-time)The date and time that the Profile was created, in Unix time format and Coordinated Universal Time (UTC).
idstringID of the Profile.
modification_timestring (date-time)The date and time that the Profile was modified, in Unix time format and Coordinated Universal Time (UTC).
namestringName of the Profile. (pattern: <code>^(?!^[0-9]+$)([a-zA-Z0-9-_' ']+)$</code>)
owner_idstringAmazon Web Services account ID of the Profile owner.
share_statusstringSharing status for the Profile. (NOT_SHARED, SHARED_WITH_ME, SHARED_BY_ME)
statusstringThe status for the Profile. (COMPLETE, DELETING, UPDATING, CREATING, DELETED, FAILED)
status_messagestringStatus message that includes additiona information about the Profile.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_profileselectprofile_id, regionReturns information about a specified Route 53 Profile, such as whether whether the Profile is shared, and the current status of the Profile.
list_profilesselectregionmaxResults, nextTokenLists all the Route 53 Profiles associated with your Amazon Web Services account.
create_profileinsertregion, ClientTokenCreates an empty Route 53 Profile.
associate_profileupdateregion, ProfileId, ResourceIdAssociates a Route 53 Profiles profile with a VPC. A VPC can have only one Profile associated with it, but a Profile can be associated with 1000 of VPCs (and you can request a higher quota). For more information, see https:​//docs.aws.amazon.com/Route53/latest/DeveloperGuide/DNSLimitations.html#limits-api-entities.
associate_resource_to_profileupdateregion, ProfileId, ResourceArnAssociates a DNS reource configuration to a Route 53 Profile.
disassociate_profileupdateprofile_id, resource_id, regionDissociates a specified Route 53 Profile from the specified VPC.
disassociate_resource_from_profileupdateprofile_id, resource_arn, regionDissoaciated a specified resource, from the Route 53 Profile.
delete_profiledeleteprofile_id, regionDeletes the specified Route 53 Profile. Before you can delete a profile, you must first disassociate it from all VPCs.

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
profile_idstringThe ID of the Profile that you want to delete.
regionstringAWS region (default: us-east-1)
resource_arnstringThe Amazon Resource Name (ARN) of the resource.
resource_idstringThe ID of the VPC.
maxResultsintegerThe maximum number of objects that you want to return for this request. If more objects are available, in the response, a NextToken value, which you can use in a subsequent call to get the next batch of objects, is provided. If you don't specify a value for MaxResults, up to 100 objects are returned.
nextTokenstringFor the first call to this list request, omit this value. When you request a list of objects, at most the number of objects specified by MaxResults is returned. If more objects are available for retrieval, a NextToken value is returned in the response. To retrieve the next batch of objects, use the token that was returned for the prior request in your next request.

SELECT examples

Returns information about a specified Route 53 Profile, such as whether whether the Profile is shared, and the current status of the Profile.

SELECT
arn,
client_token,
creation_time,
id,
modification_time,
name,
owner_id,
share_status,
status,
status_message
FROM aws.route53profiles.profiles
WHERE profile_id = '{{ profile_id }}' -- required
AND region = '{{ region }}' -- required
;

INSERT examples

Creates an empty Route 53 Profile.

INSERT INTO aws.route53profiles.profiles (
ClientToken,
Name,
Tags,
region
)
SELECT
'{{ ClientToken }}' /* required */,
'{{ Name }}',
'{{ Tags }}',
'{{ region }}'
RETURNING
profile
;

UPDATE examples

Associates a Route 53 Profiles profile with a VPC. A VPC can have only one Profile associated with it, but a Profile can be associated with 1000 of VPCs (and you can request a higher quota). For more information, see https://docs.aws.amazon.com/Route53/latest/DeveloperGuide/DNSLimitations.html#limits-api-entities.

UPDATE aws.route53profiles.profiles
SET
Name = '{{ Name }}',
ProfileId = '{{ ProfileId }}',
ResourceId = '{{ ResourceId }}',
Tags = '{{ Tags }}'
WHERE
region = '{{ region }}' --required
AND ProfileId = '{{ ProfileId }}' --required
AND ResourceId = '{{ ResourceId }}' --required
RETURNING
profile_association;

DELETE examples

Deletes the specified Route 53 Profile. Before you can delete a profile, you must first disassociate it from all VPCs.

DELETE FROM aws.route53profiles.profiles
WHERE profile_id = '{{ profile_id }}' --required
AND region = '{{ region }}' --required
;