Skip to main content

qev2_idc_applications

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

Overview

Nameqev2_idc_applications
TypeResource
Idaws.redshift.qev2_idc_applications

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idc_display_namestringThe display name for the Amazon Redshift Query Editor (QEV2) IAM Identity Center application. It appears in the console.
idc_instance_arnstringThe Amazon Resource Name (ARN) for the IAM Identity Center instance that the Amazon Redshift Query Editor (QEV2) application integrates with.
idc_managed_application_arnstringThe Amazon Resource Name (ARN) for the Amazon Redshift Query Editor (QEV2) IAM Identity Center managed application.
idc_onboard_statusstringThe onboarding status for the Amazon Redshift Query Editor (QEV2) IAM Identity Center application.
qev_2_idc_application_arnstringThe Amazon Resource Name (ARN) for the Amazon Redshift Query Editor (QEV2) application that integrates with IAM Identity Center.
qev_2_idc_application_namestringThe name of the Amazon Redshift Query Editor (QEV2) application in IAM Identity Center.
tagsstringA list of tags associated with the application. Tags are key-value pairs that you can use to organize and identify your resources.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_qev2_idc_applicationsselectregionQev2IdcApplicationArn, MaxRecords, MarkerLists the Amazon Redshift Query Editor (QEV2) IAM Identity Center applications. To retrieve additional results, use the MaxRecords and Marker parameters.
create_qev2_idc_applicationinsertIdcInstanceArn, Qev2IdcApplicationName, IdcDisplayName, regionTagsCreates an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.
modify_qev2_idc_applicationupdateQev2IdcApplicationArn, regionIdcDisplayNameModifies an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.
delete_qev2_idc_applicationdeleteQev2IdcApplicationArn, regionDeletes an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.

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
IdcDisplayNamestringThe display name for the Amazon Redshift Query Editor (QEV2) IAM Identity Center application. It appears in the console.
IdcInstanceArnstringThe Amazon Resource Name (ARN) of the IAM Identity Center instance used to create the Amazon Redshift Query Editor (QEV2) managed application.
Qev2IdcApplicationArnstringThe Amazon Resource Name (ARN) for the Amazon Redshift Query Editor (QEV2) IAM Identity Center application to delete.
Qev2IdcApplicationNamestringThe name of the Amazon Redshift Query Editor (QEV2) application in IAM Identity Center.
regionstringAWS region (default: us-east-1)
IdcDisplayNamestringThe display name for the Amazon Redshift Query Editor (QEV2) IAM Identity Center application. It appears in the console.
MarkerstringA value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.
MaxRecordsintegerThe maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.
Qev2IdcApplicationArnstringThe Amazon Resource Name (ARN) for the Amazon Redshift Query Editor (QEV2) application that integrates with IAM Identity Center.
TagsarrayA list of tags to associate with the application. Tags are key-value pairs that you can use to organize and identify your resources.

SELECT examples

Lists the Amazon Redshift Query Editor (QEV2) IAM Identity Center applications. To retrieve additional results, use the MaxRecords and Marker parameters.

SELECT
idc_display_name,
idc_instance_arn,
idc_managed_application_arn,
idc_onboard_status,
qev_2_idc_application_arn,
qev_2_idc_application_name,
tags
FROM aws.redshift.qev2_idc_applications
WHERE region = '{{ region }}' -- required
AND Qev2IdcApplicationArn = '{{ Qev2IdcApplicationArn }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;

INSERT examples

Creates an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.

INSERT INTO aws.redshift.qev2_idc_applications (
IdcInstanceArn,
Qev2IdcApplicationName,
IdcDisplayName,
region,
Tags
)
SELECT
'{{ IdcInstanceArn }}',
'{{ Qev2IdcApplicationName }}',
'{{ IdcDisplayName }}',
'{{ region }}',
'{{ Tags }}'
RETURNING
idc_display_name,
idc_instance_arn,
idc_managed_application_arn,
idc_onboard_status,
qev_2_idc_application_arn,
qev_2_idc_application_name,
tags
;

UPDATE examples

Modifies an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.

UPDATE aws.redshift.qev2_idc_applications
SET
-- No updatable properties
WHERE
Qev2IdcApplicationArn = '{{ Qev2IdcApplicationArn }}' --required
AND region = '{{ region }}' --required
AND IdcDisplayName = '{{ IdcDisplayName}}'
RETURNING
idc_display_name,
idc_instance_arn,
idc_managed_application_arn,
idc_onboard_status,
qev_2_idc_application_arn,
qev_2_idc_application_name,
tags;

DELETE examples

Deletes an Amazon Redshift Query Editor (QEV2) IAM Identity Center application.

DELETE FROM aws.redshift.qev2_idc_applications
WHERE Qev2IdcApplicationArn = '{{ Qev2IdcApplicationArn }}' --required
AND region = '{{ region }}' --required
;