Skip to main content

profiles

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

Overview

Nameprofiles
TypeResource
Idaws.b2bi.profiles

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringReturns the name of the profile, used to identify it.
business_namestringReturns the name for the business associated with this profile.
created_atstring (date-time)Returns a timestamp for creation date and time of the transformer.
emailstringReturns the email address associated with this customer profile. (pattern: <code>[\w.-]+@[\w.-]+</code>)
log_group_namestringReturns the name of the logging group.
loggingstringReturns whether or not logging is enabled for this profile. (ENABLED, DISABLED)
modified_atstring (date-time)Returns a timestamp for last time the profile was modified.
phonestringReturns the phone number associated with the profile. (pattern: <code>+?([0-9 \t-()/]{7,})(?:\s*(?:#|x.?|ext.?|extension) \t*(\d+))?</code>)
profile_arnstringReturns an Amazon Resource Name (ARN) for a specific Amazon Web Services resource, such as a capability, partnership, profile, or transformer.
profile_idstringReturns the unique, system-generated identifier for the profile. (pattern: <code>[a-zA-Z0-9_-]+</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_profileselectregionRetrieves the details for the profile specified by the profile ID. A profile is the mechanism used to create the concept of a private network.
list_profilesselectregionLists the profiles associated with your Amazon Web Services account for your current or specified region. A profile is the mechanism used to create the concept of a private network.
create_profileinsertregion, name, phone, businessName, loggingCreates a customer profile. You can have up to five customer profiles, each representing a distinct private network. A profile is the mechanism used to create the concept of a private network.
update_profileupdateregion, profileIdUpdates the specified parameters for a profile. A profile is the mechanism used to create the concept of a private network.
delete_profiledeleteregionDeletes the specified profile. A profile is the mechanism used to create the concept of a private network.

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

Retrieves the details for the profile specified by the profile ID. A profile is the mechanism used to create the concept of a private network.

SELECT
name,
business_name,
created_at,
email,
log_group_name,
logging,
modified_at,
phone,
profile_arn,
profile_id
FROM aws.b2bi.profiles
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates a customer profile. You can have up to five customer profiles, each representing a distinct private network. A profile is the mechanism used to create the concept of a private network.

INSERT INTO aws.b2bi.profiles (
name,
email,
phone,
businessName,
logging,
clientToken,
tags,
region
)
SELECT
'{{ name }}' /* required */,
'{{ email }}',
'{{ phone }}' /* required */,
'{{ businessName }}' /* required */,
'{{ logging }}' /* required */,
'{{ clientToken }}',
'{{ tags }}',
'{{ region }}'
RETURNING
name,
business_name,
created_at,
email,
log_group_name,
logging,
phone,
profile_arn,
profile_id
;

UPDATE examples

Updates the specified parameters for a profile. A profile is the mechanism used to create the concept of a private network.

UPDATE aws.b2bi.profiles
SET
profileId = '{{ profileId }}',
name = '{{ name }}',
email = '{{ email }}',
phone = '{{ phone }}',
businessName = '{{ businessName }}'
WHERE
region = '{{ region }}' --required
AND profileId = '{{ profileId }}' --required
RETURNING
name,
business_name,
created_at,
email,
log_group_name,
logging,
modified_at,
phone,
profile_arn,
profile_id;

DELETE examples

Deletes the specified profile. A profile is the mechanism used to create the concept of a private network.

DELETE FROM aws.b2bi.profiles
WHERE region = '{{ region }}' --required
;