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
;