Skip to main content

themes

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

Overview

Namethemes
TypeResource
Idaws.quicksight.themes

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
request_idstringThe Amazon Web Services request ID for this operation.
statusintegerThe HTTP status of the request.
themeobjectThe information about the theme that you are describing.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
describe_themeselectaws_account_id, theme_id, regionversion-number, alias-nameDescribes a theme.
list_themesselectaws_account_id, regionnext-token, max-results, typeLists all the themes in the current Amazon Web Services account.
create_themeinsertaws_account_id, theme_id, region, BaseThemeId, ConfigurationCreates a theme. A theme is set of configuration options for color and layout. Themes apply to analyses and dashboards. For more information, see Using Themes in Amazon Quick Sight in the Amazon Quick Sight User Guide.
update_themeupdateaws_account_id, theme_id, region, BaseThemeIdUpdates a theme.
delete_themedeleteaws_account_id, theme_id, regionversion-numberDeletes a theme.

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
aws_account_idstringThe ID of the Amazon Web Services account that contains the theme that you're deleting.
regionstringAWS region (default: us-east-1)
theme_idstringAn ID for the theme that you want to delete.
alias-namestringThe alias of the theme that you want to describe. If you name a specific alias, you describe the version that the alias points to. You can specify the latest version of the theme by providing the keyword $LATEST in the AliasName parameter. The keyword $PUBLISHED doesn't apply to themes.
max-resultsintegerThe maximum number of results to be returned per request.
next-tokenstringThe token for the next set of results, or null if there are no more results.
typestringThe type of themes that you want to list. Valid options include the following: ALL (default)- Display all existing themes. CUSTOM - Display only the themes created by people using Amazon Quick Sight. QUICKSIGHT - Display only the starting themes defined by Quick Sight.
version-numberinteger (int64)The version of the theme that you want to delete. Note: If you don't provide a version number, you're using this call to DeleteTheme to delete all versions of the theme.

SELECT examples

Describes a theme.

SELECT
request_id,
status,
theme
FROM aws.quicksight.themes
WHERE aws_account_id = '{{ aws_account_id }}' -- required
AND theme_id = '{{ theme_id }}' -- required
AND region = '{{ region }}' -- required
AND `version-number` = '{{ version-number }}'
AND `alias-name` = '{{ alias-name }}'
;

INSERT examples

Creates a theme. A theme is set of configuration options for color and layout. Themes apply to analyses and dashboards. For more information, see Using Themes in Amazon Quick Sight in the Amazon Quick Sight User Guide.

INSERT INTO aws.quicksight.themes (
Name,
BaseThemeId,
VersionDescription,
Configuration,
Permissions,
Tags,
aws_account_id,
theme_id,
region
)
SELECT
'{{ Name }}',
'{{ BaseThemeId }}' /* required */,
'{{ VersionDescription }}',
'{{ Configuration }}' /* required */,
'{{ Permissions }}',
'{{ Tags }}',
'{{ aws_account_id }}',
'{{ theme_id }}',
'{{ region }}'
RETURNING
arn,
creation_status,
request_id,
status,
theme_id,
version_arn
;

UPDATE examples

Updates a theme.

UPDATE aws.quicksight.themes
SET
Name = '{{ Name }}',
BaseThemeId = '{{ BaseThemeId }}',
VersionDescription = '{{ VersionDescription }}',
Configuration = '{{ Configuration }}'
WHERE
aws_account_id = '{{ aws_account_id }}' --required
AND theme_id = '{{ theme_id }}' --required
AND region = '{{ region }}' --required
AND BaseThemeId = '{{ BaseThemeId }}' --required
RETURNING
arn,
creation_status,
request_id,
status,
theme_id,
version_arn;

DELETE examples

Deletes a theme.

DELETE FROM aws.quicksight.themes
WHERE aws_account_id = '{{ aws_account_id }}' --required
AND theme_id = '{{ theme_id }}' --required
AND region = '{{ region }}' --required
AND `version-number` = '{{ version-number }}'
;