Skip to main content

usage_profiles

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

Overview

Nameusage_profiles
TypeResource
Idaws.glue.usage_profiles

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
configurationobjectA ProfileConfiguration object specifying the job and session values for the profile.
created_onstring (date-time)The date and time when the usage profile was created.
descriptionstringA description of the usage profile. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\r\n\t]*</code>)
last_modified_onstring (date-time)The date and time when the usage profile was last modified.
namestringThe name of the usage profile. (pattern: <code>[\u0020-\uD7FF\uE000-\uFFFD\uD800\uDC00-\uDBFF\uDFFF\t]*</code>)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_usage_profileselectregionRetrieves information about the specified Glue usage profile.
create_usage_profileinsertregionCreates an Glue usage profile.
update_usage_profileupdateregionUpdate an Glue usage profile.
delete_usage_profiledeleteregionDeletes the Glue specified usage profile.
list_usage_profilesexecregionList all the Glue usage profiles.

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 information about the specified Glue usage profile.

SELECT
configuration,
created_on,
description,
last_modified_on,
name
FROM aws.glue.usage_profiles
WHERE region = '{{ region }}' -- required
;

INSERT examples

Creates an Glue usage profile.

INSERT INTO aws.glue.usage_profiles (
Name,
Description,
Configuration,
Tags,
region
)
SELECT
'{{ Name }}',
'{{ Description }}',
'{{ Configuration }}',
'{{ Tags }}',
'{{ region }}'
RETURNING
name
;

UPDATE examples

Update an Glue usage profile.

UPDATE aws.glue.usage_profiles
SET
Name = '{{ Name }}',
Description = '{{ Description }}',
Configuration = '{{ Configuration }}'
WHERE
region = '{{ region }}' --required
RETURNING
name;

DELETE examples

Deletes the Glue specified usage profile.

DELETE FROM aws.glue.usage_profiles
WHERE region = '{{ region }}' --required
;

Lifecycle Methods

List all the Glue usage profiles.

EXEC aws.glue.usage_profiles.list_usage_profiles
@region='{{ region }}' --required
@@json=
'{
"NextToken": "{{ NextToken }}",
"MaxResults": {{ MaxResults }}
}'
;