Skip to main content

program_management_accounts

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

Overview

Nameprogram_management_accounts
TypeResource
Idaws.partnercentral_channel.program_management_accounts

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe unique identifier of the program management account. (pattern: <code>pma-[a-z0-9]{13}</code>)
account_idstringThe AWS account ID associated with the program management account. (pattern: <code>[0-9]*</code>)
arnstringThe Amazon Resource Name (ARN) of the program management account.
catalogstringThe catalog identifier associated with the account. (pattern: <code>[a-zA-Z]*</code>)
created_atstring (date-time)The timestamp when the account was created.
display_namestringThe display name of the program management account. (pattern: <code>[^\x00-\x1F\x7F]*</code>)
programstringThe program type for the management account. (SOLUTION_PROVIDER, DISTRIBUTION, DISTRIBUTION_SELLER)
revisionstringThe current revision number of the program management account. (pattern: <code>[0-9]*</code>)
start_datestring (date-time)The start date of the program management account.
statusstringThe current status of the program management account. (PENDING, ACTIVE, INACTIVE)
updated_atstring (date-time)The timestamp when the account was last updated.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_program_management_accountsselectregionLists program management accounts based on specified criteria.
create_program_management_accountinsertregion, catalog, program, displayName, accountIdCreates a new program management account for managing partner relationships.
update_program_management_accountupdateregion, catalog, identifierUpdates the properties of a program management account.
delete_program_management_accountdeleteregionDeletes a program management account.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Lists program management accounts based on specified criteria.

SELECT
id,
account_id,
arn,
catalog,
created_at,
display_name,
program,
revision,
start_date,
status,
updated_at
FROM aws.partnercentral_channel.program_management_accounts
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a new program management account for managing partner relationships.

INSERT INTO aws.partnercentral_channel.program_management_accounts (
catalog,
program,
displayName,
accountId,
clientToken,
tags,
region
)
SELECT
'{{ catalog }}' /* required */,
'{{ program }}' /* required */,
'{{ displayName }}' /* required */,
'{{ accountId }}' /* required */,
'{{ clientToken }}',
'{{ tags }}',
'{{ region }}'
RETURNING
program_management_account_detail
;

UPDATE examples

Updates the properties of a program management account.

UPDATE aws.partnercentral_channel.program_management_accounts
SET
catalog = '{{ catalog }}',
identifier = '{{ identifier }}',
revision = '{{ revision }}',
displayName = '{{ displayName }}'
WHERE
region = '{{ region }}' --required
AND catalog = '{{ catalog }}' --required
AND identifier = '{{ identifier }}' --required
RETURNING
program_management_account_detail;

DELETE examples

Deletes a program management account.

DELETE FROM aws.partnercentral_channel.program_management_accounts
WHERE region = '{{ region }}' --required
;